Answer Posted / saurav kumar

1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.

2) Stored proedure may or may not return a value but
function must return a value.

3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.

What is b tree index?

909

---

What is the order in which the sql query is executed?

932

---

What are indexers?

1080

---

What is merge?

1004

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1024

---

What is the difference between dropping a database and taking a database offline?

1164

---

What is the security principal at the server level that represents your session?

1006

---

Differentiate between ms sql server reporting services vs crystal reports?

893

---

Describe in brief sql server monitoring ways.

1047

---

List out the differences between the clustered index and non-clustered index in sql server?

996

---

What is etl - extraction, transformation, and loading?

913

---

Delete duplicate rows without using rowid.

1531

---

What are the restrictions applicable while creating views? : SQL Server Architecture

1018

---

State a few properties of relational databases?

1120

---

What does it mean to be in union?

927

---