Begin Tran programmatically

Begin Tran programmatically

Post by Matt » Sat, 02 Aug 2003 00:23:56


I have used the BEGIN TRAN statement from the Query Analyser many times when
running SQL statements that I would like to roll back if I make a mistake.

Can this be done programmatically, i.e, can I call BEGIN TRAN and then make
many UPDATE calls and then if my program produces an error I can then call
ROLLBACK.

thanks

MattC
 
 
 

Begin Tran programmatically

Post by JXSter » Sat, 02 Aug 2003 09:21:02


Just do it!

J.