CREATE VIEW Update_Pay WITH SCHEMABINDING AS SELECT FirstName, LastName, Phone, Pay FROM HumanResources.Employees

CREATE VIEW Update_Pay WITH SCHEMABINDING AS SELECT FirstName, LastName, Phone, Pay FROM HumanResources.Employees

Using the data from Table 7-2, you need to create a view that allows users to update the FirstName, LastName, Phone, and Pay columns. The code to create the view looks like this:

CREATE VIEW Update_Pay WITH SCHEMABINDING AS SELECT FirstName, LastName, Phone, Pay FROM HumanResources.Employees

Users complain they cannot use the new view to add new employees. What does this fail?

Answer – Some columns in the table are not nullable, so the view can’t be used to insert new records.
(Several nonnullable columns appear in the underlying table, so when users try to insert a new record, SQL Server expects values for all of the nonnullable columns. Since this view does not display all these columns, the view can’t be used to insert new records. It can be used to update existing records, however.)