Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What are the different acid properties?

0 Answers  

---

What is spid in sql server profiler?

0 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

What are alternate keys?

0 Answers  

---

How many types of functions are there in sql server?

0 Answers  

---

How to override dml statements with triggers?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

How do you debug a procedure in sql server?

0 Answers  

---