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

How is sql used in sql server?

0 Answers  


Where sql server usernames and passwords are stored in a sql server?

0 Answers  


please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  


What is page-level compression?

0 Answers  


What is exclusive locks?

0 Answers  






what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  


what stored procedure can you use to display the current processes? : Sql server administration

0 Answers  


define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,


Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  


Does sql server use t sql?

0 Answers  


Why and when do stored procedure recompile?

0 Answers  


What is difference between views and stored procedures?

0 Answers  


Categories