This topic has not yet been rated - Rate this topic

DatabaseOptions.IsParameterizationForced Property

SQL Server 2012

Gets or sets a Boolean property value that specifies whether parameterization is forced on the database.

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

Syntax

C++

JScript

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether parameterization is forced on the database.If True, parameterization is forced. Otherwise, False (default).

Remarks

When the IsParameterizationForced property is True, any literal value that appears that appears in a SELECT, INSERT, UPDATE, or DELETE statement is converted to a parameter during query compilation.

Examples

Setting Properties

Reference

DatabaseOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Forced Parameterization

Database Options

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD