How to sort the query output with order by clauses in ms sql server?

0 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

What is merge statement?

0 Answers  

---

what is victor class

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

---

Is it possible to update the views? If yes, how, if not, why?

0 Answers  

---

How do you persist objects, permissions in tempdb

1 Answers  

---

Explain the difference between HTTP and HTTPS in database?

0 Answers   Wipro,

---

What is the difference between dataadapter and datareader?

0 Answers  

---

What is triggers and stored procedures?

0 Answers  

---

How to define and use table alias names in ms sql server?

0 Answers  

---

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,

---