stored procedure in sql

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.

SQL Server Stored Procedure

A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.