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 join and name different type of joins?

0 Answers  


Can you type more than one query in the query editor screen at the same time?

0 Answers  


How to delete all rows with truncate table statement in ms sql server?

0 Answers  


Can two tables have the same primary key?

0 Answers  


How do I start and stop sql server?

0 Answers  






Which are the new data types introduced in sql server 2008?

0 Answers  


What does it mean if @@cursor_row returns a negative number?

0 Answers  


What is a trace frag?

0 Answers  


how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,


What is the significance of master, tempdb and model databases?

0 Answers  


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  


What are joins in sql and what are the different types of joins?

0 Answers  


Categories