SQL Transaction

Ashish Saxena

13y2kSQL

Name

Age

Department

Ashish

DotNet

Mohit

DotNet

Amit

DotNet

Hello Sir,
we have a table name - Employee & ID is auto genrate. suppose i want to delete the record with this query.

Delete from Employee Where ID=2
but after delete the record i want to again rollback how is it posible . plz explain me with easy way (i want to rollback )
and what is the diff b/w rollback & Commit

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

ashleyturnier13y ago
I like shankar M answer. its correct and this is very useful to me.
Rasadul Alam Rashed13y ago
A transaction groups a set of task into a single execution unit. Every transaction begins with a specific task and ends when all the tasks in the group successfully complete. If the execution of any of the tasks is fails, the transaction is fails. Therefore, we can say a transaction has only two results: success or failure. Any incomplete steps result in the failure of the total transaction.

You can use this: http://cybarlab.com/transactions-in-sql-server
Shankar M13y ago
Hi Ashish,

You can use Explicit Transaction to do such changes..

Explicit Transactions are nothing but where you explicitly call the start and end of the Transaction..

To Start a Transaction we specify,

BEGIN TRANSACTION

In case of Error, we specify

ROLLBACK TRANSACTION.

To End a Transaction successfully we issue,

COMMIT TRANSACTION

While using Explicit Transactions, the transaction is done as a whole or none of the Transaction is committed.
Gaurav Gupta13y ago
http://dba.stackexchange.com/questions/995/how-do-i-get-back-some-deleted-records

http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/
Ashish Saxena13y ago
actually u dint get my quest. i have to delete 1 record in my table. after that . i want to again that record . than what will use the query
Gaurav Gupta13y ago
You have to put the delete query in the transaction, so that you can rollback it...

For Example you can write the query like this....

begin tran

Delete from Employee Where ID=2

Rollback tran

You can also read the following Blog on C-SharpCorner

http://www.c-sharpcorner.com/Blogs/5318/