The key differences between SQL Server stored procedures and functions, based on the Microsoft and Azure websites: Feature Stored Procedure Function Return value Can return zero or more values Must return a single value Parameters Can have input, output, or both input and output parameters Can only have input parameters Transactions Can be used in… Continue reading SQL Server Stored Procedure vs Function