What is the difference between osql and query analyzer?

987

---

What is a join in sql?

1082

---

Why use update_statistics command in sql server?

1044

---

List out the difference between union and union all in sql server?

986

---

What are locks in sql?

974

---

In what sequence sql statement is processed?

1006

---

Explain how many types of relationship?

1019

---

What is de-normalization in sql database administration? Give examples?

981

---

List the different types of collation sensitivities in sql server?

1043

---

Why use cursor in sql server?

1075

---

Write the syntax for stuff function in an sql server?

1024

---

What does man by sql wildcard characters in sql server?

1055

---

Explain about unique identifier data type in sql server?

907

---

List all types of constraints in sql server?

1020

---

What are views used for?

1012

---