Can you have a nested transaction?

Answer Posted / visala

yes, we can have nested transactions. to know the nest
level use @@trancount

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are various limitations of the views?

792


Can sql servers linked to other servers?

730


Explain difference between control flow and data flow?

711


Can we install sql server 2016 on windows 7?

865


How to get the definition of a user defined function back?

805






How to add additional conditions in SQL?

768


Do you know what is user defined datatypes and when you should go for them?

706


If we delete pack Spec what will be the status of pack Body ?

1168


What is the difference in accessing db between sql server vs sql azure?

166


How to create a simple stored procedure in ms sql server?

704


What is an inner join?

708


What is the purpose of sql profiler in sql server? : sql server database administration

811


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

1752


Can a table be created inside a trigger?

724


Can we add our custom code in ssis?

718