PdfPrep.com

Which four Transact-SQL segments should you use to develop the solution?

DRAG DROP

You use Microsoft SQL Server client tool to develop a Microsoft Azure SQL Database instance to support an e-commerce application.

The database consists of a Product table, a Store table, and a StoreProduct table as shown in the exhibit. (Click the Exhibit button.)

You need to write a trigger that meets the following requirements:

– Stores are not physically deleted, but are marked as deleted.

– When a store is deleted, the products that are sold in that store are marked as discontinued.

Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.

Exhibit

Answer:

Exit mobile version