Propriedade do RDL Table.RowCountAsDouble

Artigo
04/26/2013

Gets the number of rows in the table as a floating point value.

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

Sintaxe

'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property RowCountAsDouble As Double 
    Get
'Uso
Dim instance As Table 
Dim value As Double 

value = instance.RowCountAsDouble

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public double RowCountAsDouble { get; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property double RowCountAsDouble {
    double get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member RowCountAsDouble : float

function get RowCountAsDouble () : double

Valor da propriedade

Tipo: System.Double
A Float64 value that specifies the number of rows in the table.

Exemplos

The following code example displays the number of rows contained in each table of the AdventureWorks2012 database.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

foreach (Table tb in db.Tables) 
{
   Console.WriteLine("The " + tb.Name + " contains " + tb.RowCountAsDouble + " rows.");
}

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

Foreach ($tb in $db.Tables) 
{
   Write-Host "The" $tb.Name "conains" $tb.RowCountAsDouble "rows."
}

Consulte também

Referência

Table Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Tabelas

CREATE TABLE (Transact-SQL)

Compartilhar via