Does the solution meet the goal?

You create a table named Products by running the following Transact-SQL statement:

You have the following stored procedure:

You need to modify the stored procedure to meet the following new requirements:

– Insert product records as a single unit of work.

– Return error number 51000 when a product fails to insert into the database.

– If a product record insert operation fails, the product information must not be permanently written to the database.

Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?
A . Yes
B . No

View Answer

Answer: B