---
title: "How many types of Transaction control in sql"  
description: "How many types of Transaction control in sql"  
author: "Jonas Stuart"  
published: 2016-07-21  
updated: 2016-07-21  
canonical: https://www.mindstick.com/forum/34154/how-many-types-of-transaction-control-in-sql  
category: "database"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# How many types of Transaction control in sql

Hi Buddy\
I want to use [Transaction](https://www.mindstick.com/blog/175/transactions-in-database) to change and modify [one table](https://www.mindstick.com/forum/538/copy-one-table-to-another-in-sql-server-automatically) to [related data](https://www.mindstick.com/interview/22990/what-is-lazy-eager-and-explicit-loading-of-related-data-in-entity-frameworks) to another table.Please tell how many types of Transaction [control](https://www.mindstick.com/blog/197/asp-dot-net-repeater-control) in sql.\
I would really appreciate your help.\
Thanks\

## Replies

### Reply by Allen Scott

**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.


---

Original Source: https://www.mindstick.com/forum/34154/how-many-types-of-transaction-control-in-sql

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.