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 is star, snowflake and star flake schema? : sql server analysis services, ssas

1130

---

What is user-defined multi-statement table-valued function?

1038

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

---

What is the most common type of join?

971

---

What are the difference between primary key and unique key? : sql server database administration

922

---

can a table be moved to different filegroup? : Sql server administration

946

---

How to retrieve field values using mssql_result()?

1281

---

What are “phantom rows”?

1642

---

What types of replication are supported in sql server?

1048

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

980

---

How to recreate an existing index in ms sql server?

1031

---

What are the filtered indexes?

1018

---

What’s the distinction between dropping a info and taking a info offline?

1023

---

How to delete an existing database user?

1001

---

Can we use max in where clause?

915

---