What is the difference between Procedure and Function

Answers were Sorted based on User's Feedback



What is the difference between Procedure and Function..

Answer / devanand

procedure can not return tye but fuction must a return type

Is This Answer Correct ?    25 Yes 1 No

What is the difference between Procedure and Function..

Answer / paporirokz

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

Is This Answer Correct ?    17 Yes 6 No

What is the difference between Procedure and Function..

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.

Is This Answer Correct ?    2 Yes 0 No

What is the difference between Procedure and Function..

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

Is This Answer Correct ?    3 Yes 10 No

Post New Answer

More SQL Server Interview Questions

What is dknf in normalization form?

0 Answers  


What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,


What is normalization of database?

0 Answers  


Why are sql functions used?

0 Answers  


What is the meaning of sql server?

0 Answers  


How to get max 100 values from sql server

7 Answers  


select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  


How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  


Explain what is “asynchronous” communication in sql server service broker?

0 Answers  


What are the different types of locks in the database?

0 Answers  


How can you check the level of fragmentation on a table?

0 Answers  


How to list all user defined functions in the current database?

0 Answers  


Categories