My interviewer asked me Question that i am inserting 10 rows in database table and in some 5th row i find the some trouble then how can i roll back all the records?
Please let me know how can i do this
+5
A:
Assuming all occur within the same transaction, use the ROLLBACK command.
OMG Ponies
2010-10-29 15:44:57
I wish I could upvote this twice, once for the right answer and another for the lol I had when I read your name. :-D
Dave
2010-10-29 15:51:47
really funny :)
NoviceToDotNet
2010-10-29 15:53:56
+1
A:
Before you insert the rows
BEGIN TRANSACTION TransactionName
[Insert Rows]
Then either
COMMIT TRANSACTION TransactionName
OR
ROLLBACK TRANSACTION TransactionName
during any problems during the insert.
DShultz
2010-10-29 15:51:32