This topic has not yet been rated - Rate this topic

OleDbProviderSettings.DynamicParameters Property

SQL Server 2012

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

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

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

Property Value

Type: 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.

Remarks

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.

Examples

Using Linked Servers in SMO

Reference

OleDbProviderSettings Class

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD