Freek's Blog

SQL en .NET vraagstukken en oplossingen die ik zoal tegenkom

posts - 199, comments - 123, trackbacks - 2, articles - 7

Google analytics script:

t-sql: count rows in tables from 1 database.

CREATE TABLE #foo

(
tablename VARCHAR(255),
rc INT
)

INSERT #foo
EXEC sp_msForEachTable
'SELECT PARSENAME(''?'', 1), COUNT(*) FROM ?'
SELECT tablename, rc
FROM #foo
ORDER BY 1 asc