Interested to Buy Any Domain ? << Click Here >> for more details...
What are explicit and implicit transactions?
- 4 Answers
- 22128 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
Does hive support indexing?
What is Transparent Data Encryption?
Explain the truncate command?
What is the difference between lock, block and deadlock? : sql server database administration
Do you know what are the reporting services components?
Tell me what is a linked server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to add a new dsn with the odbc driver for sql server?
How many categories of functions based their return modes?
Why it is recommended to avoid referencing a floating point column in the where clause?
What are the underflow and overflow behaviors on float literals?
can a table be moved to different filegroup? : Sql server administration
How to find the list of fixed hard drive and free space on server?
How to disable triggers using "disable trigger"?
Can You Use Data Mining Models In Ssrs?
