HOW MANY TYPES OF TRANSACTION CONTROL IN SQL

Jonas Stuart

Total Post:27

Points:189
Posted by  Jonas Stuart
 442  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. Allen Scott

    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. 

Answer

NEWSLETTER

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