Doesn't a procedure also 'return' a value by assigning an output parameter to it? I don't think this is so different from a function, technically speaking.

Hi Anas! Thanks for reaching out. Yes, technically they are not very different. The procedure allows SELECT as well as DML(INSERT/UPDATE/DELETE) statement in it, whereas functions allows only SELECT statement in it. Procedures cannot be utilized in a SELECT statement, whereas functions can be embedded in a SELECT statement. Hope this helps. Best, Tsvetelin

Follow this topic

Anas Alkhaldi

Last answered:

18 Mar 2022

Posted on:

12 Mar 2022

procedure can also 'return' a value by assigning an output parameter to it

in SQL / Stored routines - conclusion

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Posted on:

18 Mar 2022

procedure can also 'return' a value by assigning an output parameter to it

Submit an answer

related questions