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 IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

What is page-level compression?

0 Answers  

---

What is clr ddl trigger?

0 Answers  

---

What is sql server english query?

0 Answers  

---

explain different levels of normalization? : Sql server database administration

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

Does the unique constraint create an index?

0 Answers  

---

What are the advantages of paper records?

0 Answers  

---

How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,

---

What is faster join or union?

0 Answers  

---

What is extended stored procedures?

0 Answers  

---