Tranction in SQL Server 2008

Question

Hi What is the Tranction in SQL Server 2008 ?

Jignesh Trivedi · Answer

hi A transaction is a single unit of work. If a transaction is successful all of the data modifications made during the transaction are committed and they become a permanent part of the database. If a transaction encounters errors and then all of the data modifications are erased. BEGIN TRAN jignesh_test Select * from table1 Insert into table1 values(1'test') COMMIT TRAN jignesh_test --ROLLBACK TRAN Jignesh_test If Commit Trans is fire than one new row inserted in table1 if rollbask is called than it rollback transaction hope this will help you.

Satyapriya Nayak · Answer

Hi Arun Please refer the below links http://msdn.microsoft.com/en-us/library/ms188929.aspx http://www.codeproject.com/Articles/4451/SQL-Server-Transactions-and-Error-Handling Thanks