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
Where are sql server user names and passwords stored in sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
please differentiate between delete and truncate?
Which is faster statement or preparedstatement?
What are statistics?
Differentiate between a local and a global temporary table?
What is a database table?
Define views.
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
what are the Prerequisites for Replication?
How connect excel to sql server?
How to create a new login name in ms sql server?
What are commonly used mssql functions in php?
What are the components of dbms?
What is lookup override?