You have noticed that a particular block of Transact-SQL code triggers Error 1105. You want to determine the error state number of that particular error. You configure the appropriate TRY . . . CATCH construct.

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: 2412 | Points: 40
Select from following answers:
  1. ERROR_STATE()
  2. ERROR_NUMBER()
  3. ERROR_PROCEDURE()
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response