How does @@ERROR work?

• Wayne-153714

  Hall of Fame

  Points: 3536

  More actions

  June 25, 2004 at 4:43 am

  #108531

  In the following example code, I want to check the value of @@ERROR after an error has occured.  This code returns a error on the SELECT, and doesn't go any further.

  Will SQL only get to the IF statement based on a certain error severity?

  SELECT * FROM NoTable

  IF @@ERROR != 0

   PRINT 'ERROR!'

   

  ---

  When in doubt - test, test, test!

  Wayne
  

• Leon Bakkers

  SSC Eights!

  Points: 959

  More actions

  June 25, 2004 at 5:03 am

  #511931

  Hi,

  Have a look here

  http://www.sqlteam.com/item.asp?ItemID=2463

  Regards,

  Leon

  Regards,
  Leon Bakkers

• Riyaz Ghouse

  SSC-Addicted

  Points: 464

  More actions

  June 25, 2004 at 10:48 am

  #512005

  try...

  if @@error <> 0

  begin print 'error' end

• Razvan Socol

  SSCarpal Tunnel

  Points: 4811

  More actions

  June 28, 2004 at 4:34 am

  #512125

  For a detailed explanation of error handling in T-SQL, read an excellent article by Erland Sommarskog, SQL Server MVP:

  http://www.sommarskog.se/error-handling-II.html

  Razvan

• ikorenbl

  SSCommitted

  Points: 1750

  More actions

  June 28, 2004 at 2:00 pm

  #512272

  Once you find that @@Error is not 0, is there a way to retrieve actual SQL error message? Is there a variable like that?

  Thanks

  

• cdharma

  Valued Member

  Points: 71

  More actions

  June 28, 2004 at 2:16 pm

  #512280

  Sysmessage is the way of the warrior...

  declare @err int

  select 1/0 from syscolumns

  select @err = @@error

  select * from master..sysmessages where error = @err

   

• ikorenbl

  SSCommitted

  Points: 1750

  More actions

  June 28, 2004 at 3:28 pm

  #512293

  Thanks