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


Please Help Members By Posting Answers For Below Questions

what are the different types of SSRS reports?

122


What do you understand by coalesce in sql server?

722


How to check status of stored procedure in sql server?

653


Does any body please help me what question's have asked for SSRS in the interview?

1873


How can you list all the columns in a database?

710






How to insert new line characters into strings?

720


How to get the definition of a trigger back?

728


What are scheduled tasks in sql server?

731


what is memory-optimized nonclustered indexes

730


What will happen if a column containing char type data is changed to the nchar data type?

799


Explain active/passive and active/active cluster configurations?

796


What is the use of stored procedure?

662


How to update a field in SQL after ALTERING a row?

877


What are the different types of normalization?

807


Explain about remote stored procedure?

772