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.