SQLProcedureColumns uses the catalog stored procedure sp_sproc_columns to report the attributes of stored procedure columns.
The following table shows SQLProcedureColumns parameter mapping for sp_sproc_columns stored procedure execution.
| SQLProcedureColumns parameter name | sp_sproc_columns parameter name |
|---|---|
| CatalogName | procedure_qualifier |
| SchemaName | procedure_owner |
| ProcName | procedure_name |
| ColumnName | column_name |
SQLProcedureColumns returns one row reporting the return value attributes of all Microsoft® SQL Server™ stored procedures.
SQLProcedureColumns returns SQL_SUCCESS whether or not values exist for CatalogName, SchemaName, ProcName, or ColumnName parameters. SQLFetch returns SQL_NO_DATA when invalid values are used in these parameters.
SQLProcedureColumns can be executed on a static server cursor. An attempt to execute SQLProcedureColumns on an updatable (dynamic or keyset) cursor will return SQL_SUCCESS_WITH_INFO indicating that the cursor type has been changed.