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 the reporting service components in SSRS?

118


How to convert character strings into numeric values?

587


Explain the use of keyword with encryption. Create a store procedure with encryption?

547


Explain intellisense for query editing

578


What is GUID in sql server?

647






Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1584


When would you use it?

590


How to edit table in sql server 2017?

517


What is a covered index?

523


What are logical/boolean operations in ms sql server?

547


How is sql server used?

553


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

589


Can you explain what is sql server english query?

550


Why would you use sql agent?

740


Can we hide the definition of a stored procedure from a use?

660