What is difference between Procedures and Functions ?

Answer Posted / manojbatra071

a procedure can return none,one or more than one value but a
function can return one and only one value everytime

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to escape special characters in sql statements? : Sql dba

504


Can there be 2 primary keys in a table?

550


How many sectors are in a partition?

551


What is the current version of sql?

529


What is sql*loader and what is it used for?

571






how can we know the number of days between two given dates using mysql? : Sql dba

537


What trigger means?

559


How are sql commands classified?

587


What is sql procedures and functions?

524


How do you explain an index?

782


Why cross join is used?

622


What is the cause of mutating table error and how can we solve it?

594


How does cross join work in sql?

529


What are the different types of tables in sql?

478


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

527