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

Please illustrate physical database architecture? : SQL Server Architecture

538


What are page splits? : SQL Server Architecture

544


Explain candidate key, alternate key, and composite key?

594


What are the new security features added in sql server 2012? : sql server security

536


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1436






How is a full-text index updated?

545


How to create new tables with "select ... Into" statements in ms sql server?

518


What is 1nf 2nf and 3nf?

495


Explain following error properties?

564


What are the differences between left join and inner join in sql server?

590


Explain steps of normalization?

527


how many triggers you can have on a table? : Sql server database administration

499


What is reportserver and reportservertempdb ?

107


Explain cdc and sql injection?

552


What is the difference between count and distinct count?

468