Answer / rakesh

mojor difference is
function must return a value but a
procedure may or may not return a value

Answer / a.suresh

1.Stored Procedure return 0 to nth value where as function
return only one value which is must.
2.we can't use the stored procedure in select select
statement where as function can be used in the select statement.
3.we can use all the dml(insert,update,delete) commands in
stored procedure where as select statement only used in
functions.
4.we can use try catch in stored procedure where as in
functions cant.
function must be used with its schema where as stored
procedure used with out schema name
ex.dbo.function name

Answer / g.ashok

Stored Procedure need not to return a value.
Function should return a value.

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

How to delete a login name in ms sql server?

0 Answers  

---

What is trigger explain with program?

0 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

What are Row versions of DataRow?

0 Answers  

---

What are the tables in sql?

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---

find the 3rd max salary

10 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

What according to you is the difference between mysql and sql server performance?

0 Answers  

---

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

---