This topic has not yet been rated - Rate this topic

Stored Procedures

SQL Server 2005

A stored procedure is an executable object stored in a database. SQL Server supports:

Stored procedures
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.

Topic	Description
Running Stored Procedures (OLE DB)	Discusses how to run stored procedures using the SQL Native Client OLE DB provider.
Calling a Stored Procedure (OLE DB)	Discusses how to call stored procedures with parameters using the SQL Native Client OLE DB provider.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions