Interested to Buy Any Domain ? << Click Here >> for more details...
What are explicit and implicit transactions?
- 4 Answers
- 21906 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 the difference between grant and with grant while giving permissions to the user?
How do I debug a stored procedure in sql server?
What is the use of commit?
Which is the latest version of sql server and when it is released?
What is cross join in sql server joins?
What are the different Topologies in which Replication can be configured?
What is a rownum?
Is null vs coalesce?
What are the lambda triggers?
Difference between Sql server reporting services and Crystal reports?
What do you mean by an execution plan? How would you view it?
What is a cursor, index in sql?
Explain data warehousing in sql server?
What is the maximum size per database for sql server express?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
