Answer / devanand

procedure can not return tye but fuction must a return type

Answer / paporirokz

A function can return a value whereas a procedure cannot
return a value.

Answer / satbir singh jawla

according to the prodedure is mainly use in those language
that does not support the object so it does not give the
return type value whereare function mainly use in object
oriented language so it give the return type value some thing.

Answer / khaleek.ahmad

9.There is possible of recursive function like
max(min(something)),but there is nothing like in procedure.

10.We can call a function from a procedure, but it is not
possible to call a procedure from a function

For more detail , please see at.
http://interview-preparation-for-you.blogspot.com/2010/05/difference-between-function-and.html

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

What are the different authentication modes in sql server?

0 Answers  

---

Explain the steps needed to create a scheduled job?

0 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

What methods do you follow to protect from sql injection attack?

0 Answers  

---

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

Will the writetext statement activate a trigger?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

What is sql service broker?

0 Answers  

---

How many types of subqueries are there in sql server?

0 Answers  

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---