How many types of Transaction control in sql

Posted by  Jonas Stuart
 1200  View(s)
Ratings:
Rate this:
Hi Buddy

I want to use Transaction to change and modify one table to related data to another table.Please tell how many types of Transaction control in sql.

I would really appreciate your help.

Thanks
 
  1. Re: How many types of Transaction control in sql

    Transaction control :
    Commit : To save the changes
    Rollback: To rollback/cancel the changes
    SavePoint:To create a group of transcation which to rollback.
    Note: All the Transaction control used only DML command like Insert, Update, Delete. 

      Modified On Apr-11-2018 04:53:01 AM

Answer