Export (0) Print
Expand All

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.Deploy|SfcPropertyFlags.Matrix, 
	"true")]
public bool AnsiWarnings { get; set; }

Property Value

Type: 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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft