![]() |
Data Entry With a View |
|
Introduction |
Imagine you have a view as follows:
CREATE VIEW Personnel.EmployeesNames
AS
SELECT FirstName,
LastName,
LastName + N', ' + FirstName AS FullName FROM Persons;
GO
Here is an example of creating a record using a view:
INSERT INTO Personnel.EmployeesNames(FirstName, LastName) VALUES(N'Peter', N'Justice');