Home

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

Home Copyright © 2007-2016, FunctionX, Inc. Home