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');