Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
13 / 108
What is difference between Procedure and Function?
Answer:
Procedure are used as a script
function are used as a method
procedure can returned zero , single or multiple values
function can returned one value which is mandatory
procedure have input/output parameters
function have input parameter only
procedure can not be used in select statement
function can be used in a select statement
Asked In ::
Priyankapriyadarsini Parida
23 Feb, 2019 5:07 AM
Procedure are used as a script
function are used as a method
procedure can returned zero , single or multiple values
function can returned one value which is mandatory
procedure have input/output parameters
function have input parameter only
procedure can not be used in select statement
function can be used in a select statement