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

Can sql servers link to other servers like oracle?

0 Answers  


Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  


Can you name a few encryption mechanisms in sql server?

0 Answers  


Does full backup break log chain?

0 Answers  


What is repeatable read?

0 Answers  


What is a ddl statement?

0 Answers  


One table how may column and Primary key

3 Answers  


Do you know what is user defined datatypes and when you should go for them?

0 Answers  


What are the 7 disadvantages to a manual system?

0 Answers  


Tell me what is normalization? Explain different forms of normalization?

0 Answers  


What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  


Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,


Categories