Answer Posted / jeetu

Function can be used inside the queries but Store procedure never used inside the queries For Example Given below:

select avg(salary) from employee;// allowed here

avg(): is function

Select sp(salary) from employee // Not allowed here

sp(): is stored Procedure

Thanks

what's the maximum size of a row? : Sql server database administration

1012

---

How can I change procedure name in sql server?

973

---

How to get the definition of a stored procedure back?

919

---

What is indexed view? How to create it?

931

---

How to connect to a sql server using odbc_connect()?

1094

---

What is the difference between a check constraint and a rule?

1131

---

How do you create a clustered index?

998

---

Can we insert data into view sql server?

883

---

what is spatial nonclustered index

943

---

What are the 7 disadvantages to a manual system?

907

---

Why is replication required on the sql server?

1007

---

What is left outer join in sql server joins?

969

---

Is null in sql server?

939

---

How can I get data from a database on another server?

933

---

What do you understand by sql server agent?

906

---