An error occurs when you execute a block of Transact-SQL code, causing a transaction to roll back. You want to determine the severity of this error. You configure the appropriate TRY . . . CATCH construct, using the code so that you can further diagnose the error.

Which of the following system functions can you use to determine this information?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 2524 | Points: 40
Select from following answers:
  1. ERROR_SEVERITY()
  2. ERROR_PROCEDURE()
  3. ERROR_NUMBER()
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response