Muokkaa

Jaa


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.