• Article

UserOptions.NoCount Property

Gets or sets the Boolean property value that specifies whether queries return the number of rows affected.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy,  _
    "false")> _
Public Property NoCount As Boolean
    Get
    Set
'Usage
Dim instance As UserOptions
Dim value As Boolean

value = instance.NoCount

instance.NoCount = value

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

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy, 
    L"false")]
public:
property bool NoCount {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")>]
member NoCount : bool with get, set

function get NoCount () : boolean
function set NoCount (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies the whether queries return the number of rows affected.
If True, the number of rows affected by the query is not returned.
If False (default), the number of rows affected by the query is returned.