Microsoft 70-461 Question Answer

You use Microsoft SQL Server to develop a database application.
You create a stored procedure named usp_calculategrowth. The stored procedure modifies
rows and can result in several different exceptions.
You need to ensure that when the stored procedure is executed, the following requirements
are met:

Which six Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)

Answer: