What are explicit and implicit transactions?

Question Posted / renjusha

4 Answers
20474 Views
BirlaSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are explicit and implicit transactions?..

Answer / 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

What are explicit and implicit transactions?..

Answer / vasudeva naik

Explicit transactions must be explicitly started with the
BEGIN TRAN statement, whereas no BEGIN TRAN is necessary to
start a multistatement transaction when in implicit
transaction mode.

Is This Answer Correct ?

16 Yes

2 No

What are explicit and implicit transactions?..

Answer / anton

Implicit transactions are used automatically ACID
properties,mean would be updated or none of them would.

Explicit transactions are started by using the BEGIN
TRANSACTION T-SQL command and are stopped by using the
COMMIT TRANSACTION or ROLLBACK TRANSACTION commands.

Is This Answer Correct ?

3 Yes

3 No

What are explicit and implicit transactions?..

Answer / chintan

IMPLICIT TRANSACTION: When turned on by using "SET
IMPLICIT_TRANSACTION ON" during transaction you have to
issue 'COMMIT TRAN' command in order to commit transaction.

EXPLICIT TRANSACTION: By default in SQL Server when you
finish a transaction it is committed to the database.

Is This Answer Correct ?

9 Yes

22 No

Post New Answer