Stored procedure calls

SQL Server supports stored procedures, as a saved collection of Transact-SQL statements that can take and return user-supplied parameters.

SQL Server stored procedures can also produce one or more result sets.

To create a stored procedure in an SQL Server database, use the CREATE PROCEDURE statement. See reference documentation for more details.