What is the difference between Procedure and Function
Answers were Sorted based on User's Feedback
Answer / devanand
procedure can not return tye but fuction must a return type
| Is This Answer Correct ? | 25 Yes | 1 No |
Answer / paporirokz
A function can return a value whereas a procedure cannot
return a value.
| Is This Answer Correct ? | 17 Yes | 6 No |
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 |
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 |
What is the usage of the sign function?
What's new in sql management studio for sql server? : sql server management studio
Explain about temporary stored procedure?
How can we determine what objects a user-defined function depends upon?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
difference between sql server2000 and sql server2005
what are the different ways to return the rowcount of a table?
What is data compression?
How to create a Master database in SQL server ?
Is sql server free?
What is a dbms wizard?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)