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

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

What is data modification?

0 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

What is a collation in ms sql server?

0 Answers  

---

What is the sql profiler?

0 Answers  

---

What is split brain scenario in DB mirroring?

1 Answers  

---

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---