You can execute CSPs with a language command or through an RPC event.
You can specify the parameters for a CSP or system procedure in 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, issue the following 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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
