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

Differentiate between truncate vs delete in mssql?

683


Are all views updatable ?

892


List few advantages of stored procedure.

724


What are different types of raid levels?

747


what happens on checkpoint? : Sql server database administration

696






New concepts of sql server 2005 use in your project.

2094


What are built in functions?

757


Can we do dml on views?

727


What is the importance of three tier architecture?

816


What is difference between getdate and sysdatetime in sql server 2008?

778


What is the current limitation of the size of SQL Azure DB?

120


Explain for xml explicit mode?

734


Explain insert into select statement?

689


What is the fillfactor concept in indexes?

723


How to return the date part only from a sql server datetime datatype?

771