What are explicit and implicit transactions?
Answer Posted / vasudeva naik
Explicit transactions must be explicitly started with the
BEGIN TRAN statement, whereas no BEGIN TRAN is necessary to
start a multistatement transaction when in implicit
transaction mode.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
Can we write ddl in trigger?
What is difference between joins and subqueries?
Name three of the features managed by the surface area configuration tool? : sql server security
What is the difference between varchar and nvarchar?
List out the differences between global and local temp tables in sql server?
How does clustered and non clustered index work?
what stored procedure can you use to display the current processes? : Sql server administration
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Write a program to fetch first 10 records from a file?
State the difference between local and global temporary tables?
Do you know what is openxml in sql server?
How to count duplicated values in a column in ms sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is difference between index seek vs. Index scan?
Do you know what is user defined datatypes and when you should go for them?