Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2003-09-01 : 11:43:27
|
| Hi!!I have a friend that uses Oracle and now have to uses SQL Server 2000, he is asking me if there is any way to put commit off when he want to made some test. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-01 : 14:22:07
|
| execute a begin tran before the testthen execute rollback tran afterwards.Can also set implicit transactions on which will start a transaction but not commit it for an update.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Commit question