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 a stored procedure?
What are the requirements on sql server network connections?
What is local temp table?
What is a join in sql?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What do you understand by coalesce in sql server?
What is the sql case statement used for? Explain with an example?
What is the sql case statement used for?
How to delete a database in ms sql server?
what is the system function to get current user's user id? : Sql server database administration
How to create a dml trigger using create trigger statements?
What do you understand by check constraint in sql server?
what is the difference between Delete and Truncate command in SQL
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What area unit the various kinds of info compression introduced in sql server 2008?