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 |
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
 Posted - 2008-03-14 : 17:36:38
|
| Why is it important to use Transactions when updating or inserting multiple records ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-14 : 17:45:52
|
| Because typically the data needs to either all go in the database or none. So you need it to either all commit or all rollback. If this isn't important for your data, then transactions aren't needed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Transactions when updating