Interested to Buy Any Domain ? << Click Here >> for more details...
What are explicit and implicit transactions?
- 4 Answers
- 22103 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 are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
How to provide column names in insert statements in ms sql server?
What is standby servers? Explain types of standby servers.
How to compare the top two records using sql?
What are the results of running this script?
what are the core components of SSRS?
How many triggers are possible per table?
When a primary key constraint is included in a table, what other constraints does this imply?
Explain nested join?
What are 3 ways to get a count of the number of records in a table?
Where are SQL server users names and passwords are stored in sql server?
How do I know if localdb is running?
tell me the disaster recovery plan
Define self join in sql server joins?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
