What is difference between a PROCEDURE & FUNCTION ?
Answer Posted / pankaj mehra
Well the main difference between procedures and function is
that the procedure may/may not return any value.it can
return more than one value also.
but functions can return only one value at a time and it
must have return keyword inside the function
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Describe types of sql statements?
Is sql microsoft?
What is implicit cursor in pl sql?
What are the sql aggregate functions?
What is dialect in sql?
What is a unique key?
How do I pipe the output of one isql to another?
how can you see all indexes defined for a table? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is rtm in testing?
how to drop an existing index in mysql? : Sql dba
Explain mutating table error.
What is cost in sql execution plan?
How do you respond to dementia behavior?
Is stored procedure faster than query?