What are explicit and implicit transactions?
- 4 Answers
- 21127 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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
How to rebuild all indexes on a single table?
What are click through reports?
What is the difference between getdate and sysdatetime?
What the different components of Replication and what is their use?
how would you store your query in an SSRS report or a Database server?
How to perform key word search in tables?
What is use of except clause?
Can we write a distributed query and get some data which is located on other server and oracle database?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How to connect ms access to sql servers through odbc?
What are various limitations of the views?
What is the difference between the application object and session object?
Do you know the policy based administration feature of sql server 2008?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
