Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_execute (Transact-SQL)

SQL Server 2008

Executes a prepared Transact-SQL statement using a specified handle and optional parameter value. sp_execute is invoked by specifying ID =12 in a tabular data stream (TDS) packet.

Topic link iconTransact-SQL Syntax Conventions

sp_execute handle OUTPUT[ ,bound_param ][ ,...n ]]


Is the handle value returned by sp_prepare. handle is a required parameter that calls for int input value.


Signifies the use of additional parameters. bound_param is a required parameter that calls for input values of any data type to signify additional parameters for the procedure.


bound_param must match the declarations made by the sp_prepareparams value and can be in the form @name = value or value.

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

Community Additions

© 2015 Microsoft