Get The Record Count Of Any Table In SQL Server

Arun Kumar

10y607Code

This will return the record count of any specific table in SQL Server.

-- Approach 1
 SELECT rows FROM sysindexes WHERE id = OBJECT_ID('Asset') AND indid < 2

-- Approach 2
 select COUNT(1) from Asset