Skip to content
Home ยป stored procedure and functions in sql server

stored procedure and functions in sql server

SQL Server Stored Procedures Vs User Defined Functions

What is the difference between SQL Server Stored Procedures and User Defined Functions (UDF)?

Following are the some major difference between Stored procedures and User Defined functions

Return a value

Stored procedure may or may not return a value while UDF function must return a value.

Loading