What are explicit and implicit transactions?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is difference between view and Dip.

2013


Explain few examples of RDBMS?

619


What are the five major components of a dbms?

520


What is Sqlpaging in SqlServer 2005 ?

670


How to access the deleted record of an event?

586






How do you delete duplicate records in sql server?

517


What does ss stand for sexually?

596


What is proper subset of candidate key?

568


What is the difference between update lock and exclusive lock?

504


Can we use pragma autonomous_transaction in trigger?

552


What are the differences between left join and inner join in sql server?

594


Tell about MOM Tool(Microsoft Operator Manager)?

1424


How to filter records of table in SQL SERVER?

609


What is the report model project?

103


How to provide default values to stored procedure parameters?

589