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 are dml triggers and types of dml triggers?
what is the difference between Delete and Truncate command in SQL
syntax for deleting the database in T SQL
What is dirty read?
What are the types of sql server?
Write a SQL query in order to merge two different columns into single column?
What stored procedure can you use to display the current processes?
What is the name of the Database which IBM mainframe uses?
How to call stored procedure using http soap?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
How many types of attribute relationships are there? : sql server analysis services, ssas
What are constraints? Explain different types of constraints?
26 Answers Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,
Oracle (3253)
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)