Posts

Showing posts with the label SQL Server 2005 Rows Count

Get all Tables rows count in a database

Here is T-SQL Statment; Select A.name 'TabloAdi_TableName' , B.rowcnt 'SatirSayisi_RowCount' from sysobjects A, sysindexes B where A.id =b.id and A.type = 'u' and indid <2 order by TableName good luck,