To use procedures, know how to:
Create procedures
Call procedures from a database application
Drop or remove procedures
Control who has permission to use procedures
This section discusses these aspects of using procedures, and also describes some of the different uses of procedures.
Two system stored procedures that are useful when working with stored procedures are sp_iqprocedure and sp_iqprocparm. The sp_iqprocedure stored procedure displays information about system and user-defined procedures in a database. The sp_iqprocparm stored procedure displays information about stored procedure parameters, including these columns:
proc_name
proc_owner
parm_name
parm_type
parm_mode
domain_name
width, scale
default
