Answer Posted / aagstya

No We can not call SP inside any query! We can call only
function in query.
This is the major difference in between SQL Function and
SQL Stored Procedure

What are the purposes and advantages stored procedure?

959

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2581

---

What is the difference between the 2 operating modes of database mirroring?

1111

---

What is a trigger and types of a trigger?

983

---

What is inline table-value user-defined function?

1109

---

How do you drop an index?

920

---

How to execute stored procedure and set temp table in sql server?

1039

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1040

---

What is etl - extraction, transformation, and loading?

919

---

What is the difference between a fill factor of 100 and 0?

979

---

Does order by actually change the order of the data in the tables or does it just change the output?

1146

---

Explain the commands in sql server?

1038

---

What is the purpose of the tempdb database?

1000

---

How adventureworkslt tables are related?

926

---

what purpose does the model database serve? : Sql server database administration

977

---