DynamicParameters 屬性

Gets or sets the Boolean property value that specifies whether the provider allows '?' parameter marker syntax for parameterized queries.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DynamicParameters As Boolean
    Get
    Set
'用途
Dim instance As OleDbProviderSettings
Dim value As Boolean

value = instance.DynamicParameters

instance.DynamicParameters = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool DynamicParameters { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool DynamicParameters {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DynamicParameters : bool with get, set

function get DynamicParameters () : boolean
function set DynamicParameters (value : boolean)

屬性值

型別：System. . :: . .Boolean
A Boolean value that specifies whether SQL Server allows parameterized queries with the OLE DB provider.
If True, parameterized queries are allowed.
If False (default), parameterized queries are not allowed.

備註

Setting this option allows SQL Server to execute parameterized queries against the OLE DB provider. The ability to execute parameterized queries against the OLE DB provider can yield better performance for certain queries.

範例

在 SMO 中使用連結的伺服器

請參閱

參考

OleDbProviderSettings 類別

Microsoft.SqlServer.Management.Smo 命名空間