You can execute CSPs with a language command or through an RPC event. Specify the parameters for a CSP or system procedure in one of these 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, issue this statement:
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 cannot use this named parameter form if you process
a CSP as an RPC event.
