SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

Database Engine Stored Procedures (Transact-SQL)

sp_add_data_file_recover_suspect_db (Transact-SQL)

sp_addextendedproc (Transact-SQL)

sp_addextendedproperty (Transact-SQL)

sp_add_log_file_recover_suspect_db (Transact-SQL)

sp_addmessage (Transact-SQL)

sp_addtype (Transact-SQL)

sp_addumpdevice (Transact-SQL)

sp_altermessage (Transact-SQL)

sp_attach_db (Transact-SQL)

sp_attach_single_file_db (Transact-SQL)

sp_autostats (Transact-SQL)

sp_batch_params (Transact-SQL)

sp_bindefault (Transact-SQL)

sp_bindrule (Transact-SQL)

sp_bindsession (Transact-SQL)

sp_certify_removable (Transact-SQL)

sp_clean_db_file_free_space (Transact-SQL)

sp_clean_db_free_space (Transact-SQL)

sp_configure (Transact-SQL)

sp_control_plan_guide (Transact-SQL)

sp_create_plan_guide (Transact-SQL)

sp_create_plan_guide_from_handle (Transact-SQL)

sp_create_removable (Transact-SQL)

sp_createstats (Transact-SQL)

sp_datatype_info (Transact-SQL)

sp_db_vardecimal_storage_format (Transact-SQL)

sp_dbcmptlevel (Transact-SQL)

sp_dbmmonitoraddmonitoring (Transact-SQL)

sp_dbmmonitorchangealert (Transact-SQL)

sp_dbmmonitorchangemonitoring (Transact-SQL)

sp_dbmmonitordropalert (Transact-SQL)

sp_dbmmonitordropmonitoring (Transact-SQL)

sp_dbmmonitorhelpalert (Transact-SQL)

sp_dbmmonitorhelpmonitoring (Transact-SQL)

sp_dbmmonitorresults (Transact-SQL)

sp_dbmmonitorupdate (Transact-SQL)

sp_dboption (Transact-SQL)

sp_dbremove (Transact-SQL)

sp_delete_backuphistory (Transact-SQL)

sp_delete_database_backuphistory (Transact-SQL)

sp_depends (Transact-SQL)

sp_detach_db (Transact-SQL)

sp_dropdevice (Transact-SQL)

sp_dropextendedproc (Transact-SQL)

sp_dropextendedproperty (Transact-SQL)

sp_dropmessage (Transact-SQL)

sp_droptype (Transact-SQL)

sp_estimate_data_compression_savings (Transact-SQL)

sp_estimated_rowsize_reduction_for_vardecimal (Transact-SQL)

sp_executesql (Transact-SQL)

sp_get_query_template (Transact-SQL)

sp_getapplock (Transact-SQL)

sp_getbindtoken (Transact-SQL)

sp_help (Transact-SQL)

sp_helpconstraint (Transact-SQL)

sp_helpdb (Transact-SQL)

sp_helpdevice (Transact-SQL)

sp_helpextendedproc (Transact-SQL)

sp_helpfile (Transact-SQL)

sp_helpfilegroup (Transact-SQL)

sp_helpindex (Transact-SQL)

sp_helplanguage (Transact-SQL)

sp_helpserver (Transact-SQL)

sp_helpsort (Transact-SQL)

sp_helpstats (Transact-SQL)

sp_helptext (Transact-SQL)

sp_helptrigger (Transact-SQL)

sp_indexoption (Transact-SQL)

sp_invalidate_textptr (Transact-SQL)

sp_lock (Transact-SQL)

sp_monitor (Transact-SQL)

sp_procoption (Transact-SQL)

sp_recompile (Transact-SQL)

sp_refreshsqlmodule (Transact-SQL)

sp_refreshview (Transact-SQL)

sp_releaseapplock (Transact-SQL)

sp_rename (Transact-SQL)

sp_renamedb (Transact-SQL)

sp_resetstatus (Transact-SQL)

sp_setnetname (Transact-SQL)

sp_settriggerorder (Transact-SQL)

sp_spaceused (Transact-SQL)

sp_tableoption (Transact-SQL)

sp_unbindefault (Transact-SQL)

sp_unbindrule (Transact-SQL)

sp_updateextendedproperty (Transact-SQL)

sp_updatestats (Transact-SQL)

sp_validname (Transact-SQL)

sp_who (Transact-SQL)

sp_unprepare (Transact-SQL)

sp_prepexecrpc (Transact-SQL)

sp_prepexec (Transact-SQL)

sp_prepare (Transact SQL)

sp_execute (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

sp_prepare (Transact SQL)

SQL Server 2008

Prepares a parameterized Transact-SQL statement and returns a statement handle for execution. sp_prepare is invoked by specifying ID = 11 in a tabular data stream (TDS) packet.

Topic link icon Transact-SQL Syntax Conventions

sp_prepare handle OUTPUT, params, stmt, options

handle

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

params

Identifies parameterized statements. The params definition of variables is substituted for parameter markers in the statement. params is a required parameter that calls for an ntext, nchar, or nvarchar input value. Input a NULL value if the statement is not parameterized.

stmt

Defines the cursor result set. The stmt parameter is required and calls for an ntext, nchar, or nvarchar input value.

options

An optional parameter that returns a description of the cursor result set columns. options requires the following int input value.

Value	Description
0x0001	RETURN_METADATA

Reference

System Stored Procedures (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.