An error occurs when you execute a block of T-SQL code, causing a transaction to roll back. You want to determine the error number associated with this 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: 1501 | Points: 40
Select from following answers:
  1. ERROR_NUMBER()
  2. ERROR_STATE()
  3. ERROR_MESSAGE()
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response