What are explicit and implicit transactions?
- 4 Answers
- 21124 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
Which language rdl files made of?
What is raiseerror? What is raiseerror?
How to get @@error and @@rowcount at the same time?
What are the benefits of filtered indexes?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Explain how you can deploy an SSRS report?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the return type of executeupdate ()?
Give an example of SQL injection attack ?
What is a covering index?
How many types of functions are there in sql server?
Explain the categories of stored procedure?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What does the update command do?
how many triggers you can have on a table? : Sql server database administration
