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

Total Post:11

Points:77
Posted on    July-21-2016 7:16 AM

 Database SQL Server 
Ratings:


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

Thanks
 


Allen Scott

Total Post:41

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