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

How to create a new table in a given schema?

1190

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1208

---

what are cursors? : Sql server database administration

1064

---

When I delete any data from a table, does the sql server reduce the size of that table?

1021

---

How can we rewrite sub-queries into simple select statements or with joins?

981

---

What is tabulation?

956

---

what is the difference between a primary key and a unique key? : Sql server database administration

1008

---

What is the purpose of floor function?

1039

---

Is sql server difficult to learn?

924

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1141

---

Which is the main third-party tool used in sql server?

943

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

---

Explain about service Broker functions?

1032

---

How to convert binary strings into integers in ms sql server?

1034

---

How many types of built in functions are there in sql server 2012?

926

---