@@ERROR FUNCTION, VALIDATES T-SQL STATEMENTS AS "SET"?

• Mau-660849

  Old Hand

  Points: 311

  More actions

  September 30, 2009 at 2:30 pm

  #71875

  HELLO!

  GOOD AFTERNOON,

  Just a question, when we execute the function @@error we know it validates if the previous T-SQL statement raised an error, select, insert, update, delete, but I am not sure if @@error evaluates statements as "set", does it do it?

  For example:

  set @var=@var+10;

  if @@error <> 0

  rollback tran

  @@error is validating the "set" statement?

  thanks for your help!

  have a good day.

• ricva

  Default port

  Points: 1404

  More actions

  September 30, 2009 at 4:16 pm

  #1060220

  It should. You can test it out by setting the code to force the error:

  declare @var tinyint

  begin tran

  Print 'I do not expect an error'

  set @var=1;

  if @@error <> 0

  print 'rollback tran'

  else

  print 'nope'

  Print 'I expect an error (SET)'

  set @var=5000;

  if @@error <> 0

  print 'rollback tran'

  else

  print 'nope'

  Print 'I expect an error (SELECT)'

  SELECT @var=5000

  if @@error <> 0

  print 'rollback tran'

  else

  print 'nope'

  ROLLBACK

• Mau-660849

  Old Hand

  Points: 311

  More actions

  September 30, 2009 at 4:37 pm

  #1060230

  HEY!

  THANKS A LOT!

  IT WAS VERY USEFUL YOUR DEMONSTRATION, AND I SOLVED MY PROBLEM

  🙂