ADO and SQL Server

Defer Prepare Property

The Defer Prepare property specifies whether to prepare and perform the initial execution of a statement in a single operation.

Applies To
Command Object

Syntax

object.Properties("Defer Prepare") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Boolean that indicates how to prepare and perform initial execution of a statement, as specified in Settings.

Settings
Value Description
True A statement is prepared and initially executed in a single operation.
False Default. A statement is prepared, and then executed in two operations.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

SSPROP_DEFERPREPARE

Remarks

Setting Defer Prepare to True can result in a performance enhancement by avoiding an extra round trip to the server when a statement must be executed repeatedly.

Note  If an application calls Defer Prepare on an instance of Microsoft® SQL Server™ version 7.0, the operation is ignored.