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 test subquery results with the exists operator?

1095

---

What are the differences between left join and inner join in sql server?

1092

---

What are the types of containers in ssis?

1159

---

Explain how to use linked server?

983

---

Are resultset updatable?

943

---

How to delete a database in ms sql server?

1213

---

What is the difference between deallocate cursor and close cursor?

1245

---

Delete duplicate rows without using rowid.

1530

---

What is transaction server distributed transaction?

1037

---

How use inner join in sql server?

1118

---

Explain the functionalities that views support?

1105

---

Which data type columns are the best candidates for full-text indexing?

960

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

1034

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

942

---

Which is the latest version of sql server and when it is released?

1099

---