You can execute CSPs with a language command or through an RPC event.
To specify the parameters for a CSP, use one of the following forms:
Supply all of the parameters:
sp_columns publishers, “dbo”, “pubs2”, “pub_id”
Use “null” or a comma as a placeholder:
sp_columns publishers, null, null,”pub_id”
sp_columns publishers, , , “pub_id”
Supply one or more parameters in the following form:
@parameter_name = value
For example, to find information about a particular column:
sp_columns @table_name = publishers, @column_name = "pub_id"
The parameter names in the syntax statement must match the parameter names defined by the CSP.
You can use the named parameter form if you process a CSP as an RPC event.
