Simple Dynamic SQL to get all tables row count from the database.
You have many number of ways to get this information.
SELECT 'SELECT COUNT(*) AS '+ name +' FROM ' + name AS TableName
FROM sys.tables
You can also apply the condition to the sort the data...
WHERE name like 's%'
