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.

Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  

---

What is blocking and how would you troubleshoot it?

2 Answers  

---

How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,

---

Do you know what is sql injection?

0 Answers  

---

What is @@error in sql?

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

What is difference between temp table and cte?

0 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

how to do partition in sqlserver

0 Answers   TCS,

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

What is the process of normalization?

0 Answers  

---