What should you do?

HOTSPOT

You have a database named Sa les that contains the following database tables: Customer, Order, and Product s.

The Products table and the Order table are shown in the following diagram.

The customer table includes a column that stores the data for the last order that the customer placed.

You plan to create a table named Leads. The Leads table is expected to contain approximately 20,000 records. Storage requirements for the Leads table must be minimized.

You need to implement a stored procedure that deletes a discontinued product from the Products table. You identify the following requirements:

What should you do? To answer, select the appropriate Transact-SOL segments in the answer area.

View Answer

Answer: