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 do you understand by SQL*Net?
What is exclusive locks?
Define right outer join in sql server joins?
What do you know about system database? : SQL Server Architecture
What are the differences between DDL, DML and DCL in SQL?
How to update values in a table with update statements in ms sql server?
what is a traditional network library for sql servers? : Sql server database administration
What is attribute? : sql server analysis services, ssas
What is sql server english query?
Explain linked server in sql?
What is compression - row-level and page-level compression?
What is difference in performance between insert top (n) into table and using top with insert?
What is analysis service repository?
What are the different types of Indexes available in SQL Server?
Mention the 3 ways to get a count of the number of records in a table.