order of "RAISERROR" and "ROLLBACK TRANSACTION" in trigger

[V T]

Hello,

SQL manual generally suggests following code:

IF (some_check_within_insert_update_delete_trigger)
BEGIN
RAISERROR (....)
ROLLBACK TRANSACTON
END

My question is if anyody knows why RAISERROR (not ROLLBACK TRANSACTION) goes
first ?

Is there a particlular reason for that or difference just insignificant so
it is just a preference of a code writer ?

Any ideas ?

Thanks

[Dan Guzman]

> Is there a particlular reason for that or difference just insignificant so
> it is just a preference of a code writer ?

Unless someone chimes in otherwise, I believe the order is simply
preference. I usually ROLLBACK and then RAISERROR but I haven't been
consistent over the years.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"V T" <morea...@hotmail.com> wrote in message
news:vWHcg.23277$43....@nnrp.ca.mci.com!nnrp1.uunet.ca...