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: 