| What do you mean by transactions and their different controls in SQL Server?
When we say about the transactions in SQL Server we can defined transaction as a sequence of task which is performed on database in a logical manner to gain certains results. And different operations like creating, deleting and updating records performed in the database come from transactions.
And when we say transactions in simple language is a group of sql queries executed in database records.
Below are the 4 transactions controls:-
(1)COMMIT:-We use this to save all changes made through the transaction.
(2)ROLLBACK:-We use this to roll back transaction. And all the changes made by transaction are reverted back and the database remains as before.
(3)SET TRANSACTION:-This will used to set name of the transaction.
(4)SAVEPOINT:-We use SAVEPOINT to set the point where the transaction is to be rolled back. | | |