Answer Posted / shail

xp means extended procedure

What is the difference between functions and stored procedures?

1093

---

how can u get last observation in an unknown dataset ?

2388

---

explain different types of constraints? : Sql server database administration

915

---

What is the difference between row_number and dense_rank?

827

---

What is cursor in ms sql server?

1092

---

When is update_statistics command used?

998

---

Define magic tables in sql server?

993

---

What is a Join and explain its types?

1051

---

What is page-level compression?

905

---

Write an sql query for deleting duplicate rows?

955

---

Why people hate cursor?

1097

---

what are the important architecture components of SSRS?

124

---

What is the difference between Triggers and Stored Procedure?

1033

---

What is statement level trigger?

938

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

909

---