Skip to content

sp-prepexecrpc-transact-sql.md

Latest commit

 

History

History
53 lines (38 loc) · 1.75 KB

sp-prepexecrpc-transact-sql.md

File metadata and controls

53 lines (38 loc) · 1.75 KB
title sp_prepexecrpc (Transact-SQL)
description sp_prepexecrpc prepares and executes a parameterized stored procedure call specified using an RPC identifier.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sp_cursor_prepexecrpc
sp_cursor_prepexecrpc_TSQL
helpviewer_keywords
sp_prepexecrpc
dev_langs
TSQL

sp_prepexecrpc (Transact-SQL)

[!INCLUDE 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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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

Arguments

[!INCLUDE extended-stored-procedures]

handle

The [!INCLUDE ssNoVersion]-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.

Related content