Answer Posted / ram&saran
It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is global temp table?
Tell me what do we need queues in sql service broker?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What are the different types of subquery?
What is public role in sql server?
How to find the version of sql server? : sql server database administration
what is normalization? Explain different levels of normalization? : Sql server database administration
What is #table in sql server?
How to modify the underlying query of an existing view?
What is a trigger in sql server?
Can you please explain the difference between primary keys and foreign keys?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is linked report?
how you can configure a running aggregate in SSRS?
Tell me what is the stuff and how does it differ from the replace function?