MS SQL Server Connectivity - Re: i have two inserts and one delete i want in one transaction, is there any issue with this tsql

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: i have two inserts and one delete i want in one transaction, is there any issue with this tsql

Hari Prasad

2006-11-17, 12:12 am

Hi,

Use could use the INSERT AND DELETE inside BEGIN TRAN..COMMIT TRAN OR
ROLLBACK TRAN. Take a looks at SAVE TRANSACTION as well.

Take a look into the below URL which contains explanation and examples...

http://www.codeproject.com/database...ion
s.asp

Thanks
Hari

"Daniel" < softwareengineer9803
7@yahoo.com> wrote in message
news:eVfM9heCHHA.2328@TK2MSFTNGP02.phx.gbl...
>i have two inserts and one delete i want in one transaction, is there any
>issue with this tsql strategy: http://rafb.net/paste/results/uY2KYP16.html
>

Sponsored Links