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.

How exceptions can be handled in sql server programming?

0 Answers  

---

What is a trigger and its types?

0 Answers  

---

What is lock escalation?

1 Answers  

---

What is meant by dirty read?

0 Answers  

---

which table keeps the locking information? : Sql server administration

0 Answers  

---

What is sql stored procedure?

0 Answers  

---

How to retrieve error messages using odbc_errormsg()?

0 Answers  

---

How to count duplicated values in a column in ms sql server?

0 Answers  

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---

What is the function of inner join?

0 Answers  

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---