Answer Posted / bobby

The order of syntax for SELECT statement is

Select Top| Distinct
From Join
On
Where
Group By
Having
Oder By

But the order of execution of SELECT statement is
1.From
2.On
3.Join
4.Where
5.Group By
6.Having
7.Distinct
8.Select
9.Order By
10.Top

What is the order by used for?

1018

---

Explain a differential backup?

1007

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

953

---

What do you mean by sql server 2005 express management tools?

1299

---

Explain full-text indexing?

975

---

What is format parameter in ssrs?

146

---

Which tcp/ip port does the sql server run on? How can it be changed?

1052

---

What happens when unicode strings concatenate with non-unicode strings?

1085

---

What is thr feature of change data capture?

978

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3873

---

How to remove duplicate rows from table except one?

1005

---

How can you check the version of sql server?

1095

---

What is difference in performance between insert top (n) into table and using top with insert?

1041

---

What are the different methods available under sqlcommand class to access the data?

1119

---

What is Transparent Data Encryption?

999

---