UserOptions.AnsiWarnings Property

 

Gets or sets the Boolean property value that specifies whether warning messages are generated when nulls are encountered in aggregate functions such as SUM, AVG, MAX, MIN, STDEV, STDEVP, VAR, VARP, or COUNT.

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

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Deploy, 
	"true")]
public bool AnsiWarnings { get; set; }

Property Value

Type: System.Boolean

A Boolean value that specifies the whether a warning message is generated when null values are encountered in aggregate functions.

If True, warning messages are generated when aggregate functions encounter null values.

If False (default), warning messages are not generated when aggregate functions encounter null values.

Return to top
Show: