How should complete the stored procedure definition?

DRAG DROP

You are developing a database to track customer orders. The database contains the following tables: Sales.Customers, Sales.Orders, and Sales.OrderLines.

The following table describes the columns in Sales.Customers.

The following table describes the columns in Sales.Orders.

The following table describes the columns in Sales.OrderLines.

You need to create a stored procedure that inserts data into the Customers table.

The stored procedure must meet the following requirements:

– Data changes occur as a single unit of work.

– Data modifications that are successful are committed and a value of O is returned.

– Data modifications that are unsuccessful are rolled back. The exception severity level is set to 16 and a value of -1 is returned.

– The stored procedure uses a built-it scalar function to evaluate the current condition of data modifications.

– The entire unit of work is terminated and rolled back if a run-time error occurs during execution of the stored procedure.

How should complete the stored procedure definition? To answer, drag the appropriate Transact-SQL segments to the correct targets. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

View Answer

Answer: