Implementing Stored Procedures

This section provides the information necessary to create, modify, and remove stored procedures.

In This Section

• Creating Stored Procedures (Database Engine)
  Provides guidelines for creating stored procedures.

• Creating CLR Stored Procedures
  Describes how to create CLR stored procedures.

• Deferred Name Resolution and Compilation
  Describes when and how stored procedures are parsed and compiled. Explains deferred name resolution of referenced objects when creating a stored procedure.

• Executing Stored Procedures (Database Engine)
  Provides guidelines for executing stored procedures.

• Extended Stored Procedures
  Provides guidelines for creating extended stored procedures.

• Modifying Stored Procedures
  Provides guidelines for modifying and renamed stored procedures

• Recompiling Stored Procedures
  Provides guidelines for recompiling stored procedures.

• Viewing Stored Procedures
  Describes how to view stored procedure definitions and properties.

• Deleting Stored Procedures
  Provides guidelines for deleting stored procedures.

See Also

Concepts

Designing Stored Procedures (Database Engine)

Other Resources

Stored Procedures (Database Engine)

Understanding Stored Procedures