Answer / brahma

Yes,
Begin transaction t1
update <Table_Name> set <col1>=<col1>+50
Begin Transaction t2
delete from <Table_Name> set <col1>=<col1>+100
commit Transaction t2
end transaction t1

Answer / visala

yes, we can have nested transactions. to know the nest
level use @@trancount

Answer / swapna

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.

Answer / 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

How do you delete duplicate rows in sql server?

0 Answers  

---

What are various limitations of the views?

0 Answers  

---

What does dml stand for?

0 Answers  

---

What is store procedure? When do you use?

0 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

0 Answers  

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---

Explain triggers in sql?

0 Answers  

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---