sp-prepexecrpc-transact-sql.md

title	sp_prepexecrpc (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/02/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_cursor_prepexecrpc sp_cursor_prepexecrpc_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_prepexecrpc
ms.assetid	35d686f2-ef31-4eaa-baa9-9cef5d6c87c2
author	stevestein
ms.author	sstein

sp_prepexecrpc (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

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.

Transact-SQL Syntax Conventions

Syntax

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

Arguments

handle
Is the [!INCLUDEssNoVersion]-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 additional parameters. bound_param calls for an input value of any data type to designate the additional parameters in use.

See Also

System Stored Procedures (Transact-SQL)