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
How to sort query output in descending order in ms sql server?
Describe how to use linked server?
Explain what is it unwise to create wide clustered index keys?
What is the template in sql?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Can you edit the .rdl code associated with a linked report?
what is the main function of a query parameter?
How to find Duplicate Records In table?
application server is slow what may be the problem
What are the purposes and advantages stored procedure?
Explain collation?
What is the index requirement in SQL Azure?
What is the difference between deallocate cursor and close cursor?
How to optimize stored procedure optimization?
What are indexers?