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

How connect excel to sql server?

505


What is normalization 1nf 2nf 3nf?

628


When I delete any data from a table, does the sql server reduce the size of that table?

580


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

592


Why is there a performance difference between two similar queries where one uses union and the other uses union all?

508






What is Transparent Data Encryption?

585


Explain how would you store your query in an SSRS report or a Database server?

89


What is table constraint?

539


What is exporting utility?

539


What is an indice?

573


is it important for a database administrator to understand the operating system and file access? : Sql server administration

583


What is a select query statement in ms sql server?

578


What happens if ntwdblib.dll is missing on your machine?

632


What does <> symbol mean?

548


What are the difference between primary key and unique key? : sql server database administration

523