Home » Microsoft » 70-465 » What should you recommend?
You need to recommend a solution for the error handling of USP_4. The solution must handle errors for nested stored procedures in the code for
USP_4.
What should you recommend?
A. Use the @@ERROR variable in the nested stored procedures.
B. Use the @@ERROR variable in USP_4.
C. Use the RAISERROR command in the nested stored procedures.
D. Use the RAISERROR command in USP_4.
Correct Answer: C
Explanation/Reference:
Explanation:
* A stored procedure named USP_4 calls stored procedures in the Sales, Customers, and Inventory databases. The nested stored procedures read tables from the Sales, Customers, and Inventory databases. USP_4 uses an EXECUTE AS clause.
Reference: http://msdn.microsoft.com/en-us/library/ms178592.aspx