How many types of Transaction control in sql

Total Post:27

Points:189
 793  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. Post:46

    Points:324
    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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!