UserOptions.AnsiWarnings 속성

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.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy,  _
    "true")> _
Public Property AnsiWarnings As Boolean 
    Get 
    Set
‘사용 방법
Dim instance As UserOptions 
Dim value As Boolean 

value = instance.AnsiWarnings

instance.AnsiWarnings = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "true")]
public bool AnsiWarnings { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy, 
    L"true")]
public:
property bool AnsiWarnings {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "true")>]
member AnsiWarnings : bool with get, set
function get AnsiWarnings () : boolean 
function set AnsiWarnings (value : boolean)

속성 값

유형: 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.

SMO에서 SQL Server 구성

참고 항목

참조

UserOptions 클래스

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

SMO에서 SQL Server 구성

NIB user options 옵션