Home > DeveloperSection > Forums > How many types of Transaction control in sql
Jonas Stuart
Jonas Stuart

Total Post:11

Posted on    July-21-2016 7:16 AM

 Database SQL Server 

 1 Reply(s)
 171  View(s)
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.


Allen Scott

Total Post:41

Posted on    July-21-2016 7:37 AM

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. 

Don't want to miss updates? Please click the below button!

Follow MindStick