Answer Posted / mona

Function can return at most one value at a time while
procedure can return more than one value at a time You can
use function within Sql Statement and you cannot use stored
procedure with in Sql Statement

Explain what is lock escalation?

997

---

What are the advantages of stored procedure in sql server?

841

---

What is openxml in sql server?

1120

---

What is faster join or union?

1123

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1102

---

What is mean by candidate key?

957

---

What is sql server profiler?

962

---

what is the system function to get current user's user id? : Sql server database administration

959

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

925

---

how you can deploy an ssrs report?

174

---

What are the differences between decimal and float in ms sql server?

1135

---

Mention a few common trace flags used with sql server?

891

---

What does asynchronous call backs means?

1081

---

can an order by clause be used in a creation of a view?

1115

---

What is optimization and its types?

924

---