You write block of Transact-SQL code in try/catch block. You need to determine the error severity, if any error takes pace during execution of store procedure so that you can take further step to rectify it.

Which system function you can use for that ?

 Posted by Rajkatie on 12/31/2012 | Category: Sql Server Interview questions | Views: 5707 | Points: 40
Select from following answers:
  1. ERROR_SEVERITY()
  2. ERROR_PROCEDURE()
  3. ERROR_STATE()
  4. All Above

Show Correct Answer


Source: Measureup.com | | Alert Moderator 

Comments or Responses

Login to post response