Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
hi,
 
Can anyone know?
 
what is commit and rollback in sql with example?
Posted 19-Feb-12 18:09pm
Comments
Varun Sareen at 20-Feb-12 0:29am
   
search google dear
sathiyak at 20-Feb-12 0:30am
   
got it...
Varun Sareen at 20-Feb-12 1:01am
   
good!!!
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Commit and Rollback mainly used with transaction.
see Transactions in SQL Server
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

IN SIMPLE WORDS-->
 
COMMIT used to permanently store the task (insert/delete/update operations) you have done since u have started ur transaction.

ROLLBACK is used to revert all the task (insert/delete/update operations)   you have done since u have started ur transaction.And the state of ur data base will be at the point of ur BEGIN TRANSACTION.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Dnyaneshwar@Pune 994
1 Sergey Alexandrovich Kryukov 826
2 OriginalGriff 448
3 Tadit Dash 390
4 sanket saxena 323
0 Sergey Alexandrovich Kryukov 11,800
1 OriginalGriff 7,225
2 Peter Leow 5,009
3 Abhinav S 3,893
4 Maciej Los 3,575


Advertise | Privacy | Mobile
Web03 | 2.8.140421.2 | Last Updated 20 Feb 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid