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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-11 : 13:58:09
|
| venkat writes "Sir,Please explain me the transactions in sql server 7.0 with examples as simple as possible.waiting for your reply.regardsvenkat" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-09-11 : 14:48:54
|
| Transactions are a method to ensure all related data gets updated. Specifically, when there is more than one change to data to be made, such as a bank inserting a record for a deposit and updating the current balance (assuming it's not just calculated), if either the insert or the update failed, you would want the entire transaction to be rolled back or "undone" instead of only half of it being done.You can find more info in SQL Server Books Online that comes with your copy of SQL Server. |
 |
|
|
|
|
|
SQL