Interested to Buy Any Domain ? << Click Here >> for more details...
What are explicit and implicit transactions?
- 4 Answers
- 21907 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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 does set rowcount do?
what's the difference between a primary key and a unique key? : Sql server database administration
Explain the ways to controlling cursor behavior?
Explain external key management in sql server 2008
What do you mean by a Composite primary key?
Explain different types of lock modes in sql server 2000?
Explain the collation?
How to connect Azure federated root database and apply federation in entity framework?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What are scalar functions?
How important do you consider cursors or while loops for a transactional database?
How to insert multiple rows with a subquery?
When we should use and scope of @@identity?
How to bind a view to the schema of the underlying tables?
 Explain what is sql override for a source taLle in a mapping?
