Count Number of Rows In Microsoft SQL Table February 16, 2016 by Mike To count the number of rows in a Microsoft SQL database table: SELECT COUNT(*) FROM dbo.table_name;