What are explicit and implicit transactions?
Answer Posted / anton
Implicit transactions are used automatically ACID
properties,mean would be updated or none of them would.
Explicit transactions are started by using the BEGIN
TRANSACTION T-SQL command and are stopped by using the
COMMIT TRANSACTION or ROLLBACK TRANSACTION commands.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what are the different types of SSRS reports?
What do you understand by coalesce in sql server?
How to check status of stored procedure in sql server?
Does any body please help me what question's have asked for SSRS in the interview?
How can you list all the columns in a database?
How to insert new line characters into strings?
How to get the definition of a trigger back?
What are scheduled tasks in sql server?
what is memory-optimized nonclustered indexes
What will happen if a column containing char type data is changed to the nchar data type?
Explain active/passive and active/active cluster configurations?
What is the use of stored procedure?
How to update a field in SQL after ALTERING a row?
What are the different types of normalization?
Explain about remote stored procedure?