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

What are the types of indexes?

590

---

How fixed length strings are truncated and padded?

548

---

What is the difference between NOROW and LOCKROW?

2233

---

What are system databases into sql server (2005/2008) : sql server database administration

566

---

what is a join and explain different types of joins? : Sql server database administration

536

---

---

What are sql dirty pages?

552

---

Is sql different from sql server?

511

---

How can we migrate from SQL server to SQL Azure?

92

---

Ways to improve the performance of a SQL Azure Database?

103

---

Tell me about pre-defined functions of sql?

691

---

What stored by the master? : sql server database administration

575

---

What are statistics?

566

---

How to check parameter value in stored procedure sql server?

462

---

What is the template in sql?

537

---

How do I run a trace in sql server?

498

---