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 an active database?
What is correlated subquery in sql server?
Can we linked SharePoint to a SQL database?
What is the most common type of join?
How to drop existing views from a database in ms sql server?
How to skip remaining statements in a loop block using continue statements?
How the authentication mode can be changed?
What command must you use to include the not null constraint after a table has already been created?
Tell me can we use custom code in ssrs?
How to create and drop temp table in sql server?
Is sql different from sql server?
What are synonyms?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How can you fetch alternate records from a table?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
