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.

Posted on Tuesday, November 16, 2010 11:52 AM

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

7/25/2011 5:23 AM by RIFT Power Leveling

thanks

Title

Name

Url

Comment

Remember Me?

ATTENTION: the code you need to copy is CaSe SeNsItIvE and is required to prevent spam.

Enter the code you see: