What is Difference between Function and Stored Procedure?

Posted by

To view Verified answers click on the button below.

UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section
where as Stored procedures cannot be. UDFs that return tables can be treated as another
row set. This can be used in JOINs with other tables. Inline UDF’s can be thought of as views
that take parameters and can be used in JOINs and other Row set operations.