What is COMMIT and ROLLBACK statement in SQL

 Posted by Chikul on 12/21/2009 | Category: Sql Server Interview questions | Views: 2786

Commit statement helps in termination of the current transaction and do all the changes that occur in transaction persistent and this also commits all the changes to the database.
ROLLBACK do the same thing just terminate the currenct transaction but one another thing is that the changes made to database are ROLLBACK to the database.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response