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

What is triggers and stored procedures?

0 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

State the difference between local and global temporary tables?

0 Answers  

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---

What do you mean by sql server 2005 express management tools?

0 Answers  

---

What is partition index in sql server?

0 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

Does view occupy space?

0 Answers  

---

Explain what are the database objects? : SQL Server Architecture

0 Answers  

---

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---