Multiple conditions if...else

[rosn459]

Is this logic correct?

IF (@ErrorSaveVariable = 11 or @ErrorSaveVariable = 23 )

BEGIN

PRINT 'Errors encountered, rolling back.'

PRINT 'Last error encountered: ' +

CAST(@ErrorSaveVariable AS VARCHAR(10))

ROLLBACK

END

 

[ESquared]

It looks okay, what's the problem?

I would put ROLLBACK TRAN[SACTION] but maybe you can leave the TRAN off.

Did you start with a BEGIN TRANSACTION or is this inside a trigger?

-------------------------------------
A sacrifice is harder when no one knows you've made it.

 

[rosn459]

No problem - I'm just checking syntax and logic. I am retrofitting a proc and there was similar logic. I got a funky error and was going through double-checking everything.


Thanks for the second look!