What are explicit and implicit transactions?
Answer Posted / lara
When a connection is operating in implicit transaction mode
MS SQL automatically starts a new transaction after the
current transaction is committed or rolled back.Implicit
transaction mode generates a continuous chain of
transactions.
An explicit transaction is one in which you explicitly
define both the start and end of the transaction.A user has
to use the BEGIN TRANSACTION, COMMIT TRANSACTION, COMMIT
WORK, ROLLBACK TRANSACTION, or ROLLBACK WORK Transact-SQL
statements to define explicit transactions.
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
What is a cache in ssrs?
What the different components of Replication and what is their use?
How network traffic be reduced by using the stored procedure?
Is t sql the same as sql server?
Explain the flow of creating a cube? : sql server analysis services, ssas
Tell me when is the update_statistics command used?
What is the function of sql server agent windows service?
What is de-normalization in sql database administration? Give examples?
Where is localdb stored?
what is the sql equivaent of the dataset relation object ?
How do I find the sql server instance name?
Can you pass expressions to stored procedure parameters?
What is the difference between upgrade and migration in sql server?
What is the difference between local and global temporary tables?
What stored by the tempdb ? : sql server database administration