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
What is the purpose of self join?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How dts is used to extract, transform and consolidate data?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What command is used to rename the database?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
what kind of lan types do you know? : Sql server database administration
what type of index will get created after executing the above statement? : Sql server database administration
What is mapping schema?
What is 3nf normalization?
can we have a nested transaction? : Sql server database administration
What are partitioned views?
What happens to a trigger with multiple affected rows?
What do you mean by subquery?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation