Proprietà Table.RowCount
Gets the number of rows in the table.
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property RowCount As Long
Get
'Utilizzo
Dim instance As Table
Dim value As Long
value = instance.RowCount
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public long RowCount { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property long long RowCount {
long long get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member RowCount : int64
function get RowCount () : long
Valore proprietà
Tipo: System.Int64
An Int64 value that specifies the number of rows in the table.
Esempi
The following code example displays the number of rows contained in each table of the AdventureWorks2012 database.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];
foreach (Table tb in db.Tables)
{
Console.WriteLine("The " + tb.Name + " contains " + tb.RowCount + " 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.RowCount "rows."
}
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo