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
How you provide security to cube? : sql server analysis services, ssas
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
How to create stored procedures with parameters in ms sql server?
What does this statement do @@rowcount?
What is the difference between mysql and sql server?
What is difference between count (*) and count column?
What are the benefits of normalization?
What are the different sql server versions?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
How do I create a stored procedure in dbml?
what is sql server? : Sql server database administration
What are the different authentication modes in sql server? How can it be changed?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
How to maintain a fill factor in existing indexes?
How to search for a string in all stored procedure in sql server?