...

View Full Version : transaction, commits and rollbacks HOW TO



atferraz
10-19-2003, 02:30 AM
NEED to apply transactions, commits and rollback to a script with a lot of inserts (sql server)

thanks anyone.

raf
10-19-2003, 10:30 AM
There have been quite some threads about it. Like

http://www.codingforums.com/showthread.php?s=&threadid=19116&highlight=transaction

ASP-Hosting.ca
10-19-2003, 05:03 PM
Originally posted by atferraz
NEED to apply transactions, commits and rollback to a script with a lot of inserts (sql server)

thanks anyone.

Hi,

You can do the transactions from your ASP code using ADO:

' oConn is your ADO connection object
oConn.BeginTrans
oConn.CommitTrans
oConn.RollbackTrans

or you can do your transactions within your stored procedures in the SQL Server.

atferraz
10-19-2003, 06:48 PM
thank you all. got that.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum