User Id :    Password :      New Member   Forgot Password  
Topic: Transaction in SQL?
Anamika singh
22 Nov 2010 at 11:38 PM

Transaction in SQL?

Re: Transaction in SQL?
16 Dec 2010 at 04:27 AM
A SQL Modification Statement has limited effect. A given statement can only directly modify the contents of a single table (Referential Integrity effects may cause indirect modification of other tables.) The upshot is that operations which require modification of several tables must involve multiple modification statements. A classic example is a bank operation that transfers funds from one type of account to another, requiring updates to 2 tables. Transactions provide a way to group these multiple statements in one atomic unit.

In SQL92, there is no BEGIN TRANSACTION statement. A transaction begins with the execution of a SQL-Data statement when there is no current transaction. All subsequent SQL-Data statements until COMMIT or ROLLBACK become part of the transaction. Execution of a COMMIT Statement or ROLLBACK Statement completes the current transaction. A subsequent SQL-Data statement starts a new transaction.

Total Replies: 1
Featured Text Ad

Featured Ad