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 to get the definition of a trigger back?

0 Answers  

---

Explain about unique identifier data type in sql server?

0 Answers  

---

What are a scheduled jobs?

0 Answers  

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

What is a DBMS, query, SQL?

0 Answers   Maveric,

---

What are various limitations of the views?

0 Answers  

---

What is an Index?

3 Answers   Yardi Software,

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

How adventureworkslt tables are related?

0 Answers  

---

What does it mean to normalize a database and why would you do it?

0 Answers  

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---

What does executeupdate return?

0 Answers  

---