All SQL Server stored procedures return a value. SQLProcedures reports SQL_PT_FUNCTION for the result set column PROCEDURE_TYPE.

SQLProcedures returns SQL_SUCCESS whether or not values exist for CatalogName, SchemaName, or ProcName parameters. SQLFetch returns SQL_NO_DATA when invalid values are used in these parameters.

SQLProcedures can be executed on a static server cursor. An attempt to execute SQLProcedures on an updatable (dynamic or keyset) cursor will return SQL_SUCCESS_WITH_INFO, indicating that the cursor type has been changed.

SQLProcedures returns information about any tables whose names match ProcName and are owned by the current user.

Community Additions