Answer Posted / hardik

stored procedures are bunch of SQL queries. main advantage
of stored procedure is that it is a self compiled and
execution speed is faster than normal query.

for e.g.

if we write select * from tablename and if we make stored
proc for that statement it will execute faster than normal
query.

What are sql servers used for?

1047

---

Tell me what is the order in which the sql query is executed?

948

---

Tell me the phases a transaction has to undergo?

962

---

What is difference between join and natural join?

969

---

Describe the left outer join & right outer join. : sql server database administration

996

---

What are rows and columns?

1019

---

Can You Use Data Mining Models In Ssrs?

145

---

How do you clear a log file?

1048

---

System variable and temporary variables

2250

---

What is snapshot parameter in ssrs?

150

---

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

1023

---

What is constraints and its types?

949

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1041

---

Do you know how to send email from database?

1005

---

Can we call stored procedure in view in sql server?

898

---