What are explicit and implicit transactions?
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
Explain Geography datatype in SQL Server
What is mean by candidate key?
Where to find ntwdblib.dll version 2000.80.194.0?
What is user defined datatypes and when you should go for them?
Tell me what is fill factor?
Tell me what is de-normalization and what are some of the examples of it?
What is use of @@ spid in sql server?
What are data regions?
Why I am getting this error when renaming a database in ms sql server?
What is cte (common table expression)?
What do you understand by recursive stored procedure?
Do you know what is a with(nolock)?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is an indexing technique?
What is checkpoint process in the sql server?