Can you have a nested transaction?

Answer Posted / swapna

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can delete duplicate records in cte in sql server?

524


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1579


explain different levels of normalization? : Sql server database administration

524


Is the order of columns in the set clause important in ms sql server?

521


What is sql collation?

655






Explain syntax for dropping triggers?

524


What is the minimum recommended amount of ram for sql server 2012 enterprise?

515


What is the boxing and unboxing concept in .net?

550


What is federation member?

93


Explain about remote stored procedure?

593


How to find the source of a table in sql server?

529


Write a SQL query to delete a table?

655


What is dbcc updateusage?

538


System requirements for sql server 2005 express edition?

569


What is the use of sql profiler in sql server 2012?

515