You run the following Transact-SQL statements:
Records must only be added to the Orders table by using the view. If a customer name does not exist, then a new customer name must be created.
You need to ensure that you can insert rows into the Orders table by using the view.
Select an option, then click Submit answer.
-
○
Add the CustomerID column from the Orders table and the WITH CHECK OPTION statement to the view.
-
○
Create an INSTEAD OF trigger on the view.
-
○
Add the WITH SCHEMABINDING statement to the view statement and create a clustered index on the view.
-
○
Remove the subquery from the view, add the WITH SCHEMABINDING statement, and add a trigger to the Orders table to perform the required logic.
