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 |
|
requestor
Starting Member
17 Posts |
 Posted - 2007-10-11 : 11:24:21
|
| Hai, Im using Sql server 2000. Im writing appliction to do Batch Update, meaning updating more than one row in single database call..In my Requirment i may get around 2000 record to update...so i want to us Savepoint after every 200 records are updated to the database..Can i use save point for my requirment...can someone clarify |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-11 : 11:42:46
|
| yes transaction do have savepointslook up SAVE TRANSACTION in BOL._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-11 : 15:16:00
|
| "i may get around 2000 record to update..."Insert them to Temp Table, without Transaction, and then Insert them to Real Table as a single, Atomic, action. Otherwise you are Locking / Blocking the table for an unreasonably long time.Kristen |
|
|
|
requestor
Starting Member
17 Posts |
Posted - 2007-10-11 : 18:42:46
|
quote:
Originally posted by Kristen
"i may get around 2000 record to update..."Insert them to Temp Table, without Transaction, and then Insert them to Real Table as a single, Atomic, action. Otherwise you are Locking / Blocking the table for an unreasonably long time.Kristen
Hai, thanks for ur suggestion..Yes, im planning to store all the record in temp table(2000 records). then have save point after 200 records...Update 200 records first...if there is no problem updating first 200 records, commit the transaction...Then come back and repeat the process...This is my idea... |
|
|
|
|
|
|
|
|
save Transaction