A stored procedure (Stored Procedures (Database Engine)) is an executable object stored in a database. SQL Server supports:
One or more SQL statements that have been precompiled into a single executable procedure.
Extended stored procedures
C or C++ dynamic-link libraries (DLLs) written to the SQL Server Open Data Services API for extended stored procedures. The Open Data Services API extends the capabilities of stored procedures to include C or C++ code.