Which three actions should you perform is sequence?

DRAG DROP

You create tables by using the following Transact-SQL statements: Each customer may have multiple addresses but only one is the primary address.

You must plan a solution that meets the following requirements:

Return both customers and address information.

Return only the primary address of the customer.

Allow updates of all customer information and address details with the exception of the identity columns and the IsActive column.

Which three actions should you perform is sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

Step 1: SQL Server Views WITH CHECK OPTION. Views can be created in SQL Server WITH CHECK OPTION. WITH CHECK OPTION will make sure that all INSERT and UPDATE statements executed against the view meet the restrictions in the WHERE clause, and that the modified data in the view remains visible after INSERT and UPDATE statements.

Step 2-3: INSTEAD OF triggers can be created on a view to make a view updatable.

References:

http://zarez.net/?p=3002

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-2017