There are three types of transactions.
1)Auto commit transaction
2)Implicit transaction
3)Explicit transaction
1)Auto commit transaction : This is the default transaction mode in sql server.Every SQL statement in sql server is either committed or rolled back. If it completes successfully it is committed else it is rolled back.
2)Implicit transaction : A new transaction is starts automatically when the current transaction is committed or rolled back.No need to define the start of the transaction. It generates continues chain of transactions.
3)Explicit transaction : ransactions that have a START and END explicitly written are called as an explicit transaction. They last only for the duration of the transaction.
1)Auto commit transaction
2)Implicit transaction
3)Explicit transaction
1)Auto commit transaction : This is the default transaction mode in sql server.Every SQL statement in sql server is either committed or rolled back. If it completes successfully it is committed else it is rolled back.
2)Implicit transaction : A new transaction is starts automatically when the current transaction is committed or rolled back.No need to define the start of the transaction. It generates continues chain of transactions.
3)Explicit transaction : ransactions that have a START and END explicitly written are called as an explicit transaction. They last only for the duration of the transaction.
No comments:
Post a Comment