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.

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  

---

What is use of @@ spid in sql server?

0 Answers  

---

What do you need to connect php to sql server?

0 Answers  

---

What is meant by indexing?

0 Answers  

---

What is the difference between getdate and sysdatetime?

0 Answers  

---

What does select 1 mean?

0 Answers  

---

What happens if time-only values are provided as date and time literals?

0 Answers  

---

What is a trigger what are the advantages of trigger?

0 Answers  

---

Explain intellisense for query editing

0 Answers  

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

---

What are the different types of lock modes in sql server 2000?

0 Answers  

---