Diffrenece Between Function and Procedure in SQL Server

Following are the main differences between sql server stored procedure and sql server user defined function.

Stored procedure does not return values but it returns a integer value indicates that stored procedure executed successfully. While user defined function in sql server must return a single value. You can not return more than one value in user defined function.

You can call user defined function in stored procedure while you can not call extended stored procedure in user defined function in sql server.