Skip to main content

SqlProc (Query Keyword)

Specifies whether the query can be invoked as an SQL stored procedure.

Usage

To specify that the query can be invoked as an SQL stored procedure, use the following syntax:

Query name(formal_spec) As classname [ SqlProc ] {    //implementation }

Otherwise, omit this keyword or place the word Not immediately before the keyword.

Details

This keyword specifies whether the query can be invoked as an SQL stored procedure. In this case, the query is visible via the INFORMATION_SCHEMA.Routines and INFORMATION_SCHEMA.Parameters tables.

Default

If you omit this keyword, the query cannot be invoked as an SQL stored procedure and the query is not visible in the INFORMATION_SCHEMA.Routines and INFORMATION_SCHEMA.Parameters tables.

See Also

FeedbackOpens in a new tab