SQL Transaction

Question

ID

Name

Age

Department

1

Ashish

25

DotNet

2

Mohit

26

DotNet

3

Amit

24

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

ashleyturnier · Answer

I like shankar M answer. its correct and this is very useful to me.

Rasadul Alam Rashed · Answer

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 M · Answer

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 Gupta · Answer

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 Saxena · Answer

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 Gupta · Answer

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/