Click here to Skip to main content
12,884,793 members (31,636 online)
Rate this:
 
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 20-Feb-12 0:29am
   
search google dear
sathiyak 20-Feb-12 0:30am
   
got it...
Varun Sareen 20-Feb-12 1:01am
   
good!!!
King_Fisher 26-Jun-14 8:12am
   
google it
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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 24 Jun 2014
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100