Interested to Buy Any Domain ? << Click Here >> for more details...
What are explicit and implicit transactions?
- 4 Answers
- 22123 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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 many types of stored procedures are there in sql server?
Tell me in brief how sql server enhances scalability of the database system?
how can u get last observation in an unknown dataset ?
What is a join in sql? What are the types of joins?
Can you explain different types of locks in sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is inner join in sql server joins?
Differentiate between a having clause and a where clause.
can we have a nested transaction? : Sql server database administration
What is optimization and its types?
What is database black box testing?
What is cursor in ms sql server?
what types of replication are supported in sql server? : Sql server database administration
What are window functions in sql server?
How we create SQL Server 2005 Reporting Services ? Give me Sample
