Export (0) Print
Expand All
Expand Minimize

sp_prepexecrpc (Transact-SQL)

SQL Server 2008

Prepares and executes a parameterized stored procedure call that has been specified using an RPC identifier. sp_prepexecrpc is invoked by ID = 14 in a tabular data stream (TDS) packet.

Topic link iconTransact-SQL Syntax Conventions

sp_prepexecrpc handle, OUTPUT RPCCall    [ , bound_param ][ ,...n ]]


Is the SQL Server-generated prepared handle identifier. handle is a required parameter with an int return value.


Defines the SP call using ODBC canonical syntax. RPCCall is a required parameter that calls for an ntext string input value. See the Example section later in this topic for additional information.


Signifies the optional use of additional parameters. bound_param calls for an input value of any data type to designate the additional parameters in use.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft