Interested to Buy Any Domain ? << Click Here >> for more details...
What are explicit and implicit transactions?
- 4 Answers
- 22106 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is partitioned view?
How data can be copied from one table to another table?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Are connections to sql server encrypted?
Why de-normalization required?
What are unicode character string data types in ms sql server?
List out the differences between the clustered index and non-clustered index in sql server?
What is the difference between update lock and exclusive lock?
What are the various editions of sql server 2017 that are available in the market?
How to execute multiple stored procedures at one time in sql server?
How retrieve field names from the table in SQL through JAVA code?
What is transaction server distributed transaction?
what is a sub-report?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is a with(nolock)?
