Stored procedures / Calling stored procedures with supported databases |
SQL Server implements stored procedures, which are 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.