Interested to Buy Any Domain ? << Click Here >> for more details...
What are explicit and implicit transactions?
- 4 Answers
- 22122 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 BLOCK statements in SQL?
Can a database be shrunk to 0 bytes, if not, why?
What is usually the first word in a sql query?
How do I partition a table in sql server?
Explain an incremental backup?
Why truncate is ddl command?
Explain various On-Delete options in a DB table. Which is the default option?
please differentiate between delete and truncate?
What is dml command?
Is it important for a database administrator to understand the operating system and file access?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Why do we use non clustered index?
What is the importance of a recovery model?
What are the differences between user defined functions and stored procedures?
How to retrieve field values using mssql_result()?
