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 a join and their types?

2 Answers   Challenger Financial,


What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,


What are the differences between ms sql server & oracle?

0 Answers  


Explain insert into select statement?

0 Answers  


Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,






What are the parts of a function?

0 Answers  


How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  


How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  


What is compression - row-level and page-level compression?

0 Answers  


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

0 Answers  


Tell me the phases a transaction has to undergo?

0 Answers  


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


Categories