What is the drawback of Drawback of @@Error?

 Posted by Niladri.Biswas on 5/16/2013 | Category: Sql Server Interview questions | Views: 2235 | Points: 40
Answer:

1)Checking for @@Error must be done immediately after execution of a statement.

2)As @@ Error values changes with every execution of statement in the code we need to use a local variable to store the @@error value and use it whenever needed.

3)Along with the custom error, the system defined error also appears


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response