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

How can you fetch alternate records from a table?

912

---

Explain about the command-line tool SQLCMD?

1018

---

Can a table be created inside a trigger?

920

---

What is an execution plan? When would you use it?

919

---

What is the main purpose of having conversation group?

846

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

Explain “not null constraint” in sql server?

955

---

What are the advantages of using cte?

951

---

What is function of master database?

114

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2043

---

Do you know what is a with(nolock)?

993

---

Where are SQL server users names and passwords are stored in sql server?

1196

---

What happens if ntwdblib.dll is missing on your machine?

1098

---

Explain indexing and what are the advantages of it?

962

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1007

---