sp_prepexecrpc (Transact-SQL)
Applies to:
SQL Server
Prepares and executes a parameterized stored procedure call specified using a remote procedure call (RPC) identifier. sp_prepexecrpc
is invoked by ID = 14
in a tabular data stream (TDS) packet.
Transact-SQL syntax conventions
Syntax
sp_prepexecrpc handle OUTPUT , RPCCall
[ , bound_param ] [ , ...n ]
[ ; ]
Arguments
Important
Arguments for extended stored procedures must be entered in the specific order as described in the Syntax section. If the parameters are entered out of order, an error message occurs.
handle
The SQL Server-generated prepared handle identifier. handle is a required parameter with an int return value.
RPCCall
Defines the stored procedure call using ODBC canonical syntax. RPCCall is a required parameter that calls for an ntext string input value.
bound_param
Signifies the optional use of extra parameters. bound_param calls for an input value of any data type to designate the extra parameters in use.