Rows in Table

Question

Rows in Table

Jonathan Matt

SSCarpal Tunnel

Points: 4027
More actions
August 26, 2002 at 10:33 am

#158086

What would be the best way to get the number of rows in a table from a SQL script? Is there a sp for this or DMO statement?
Thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 1

Here is a script that returns record counts for every table in every database on your server. From this you should get some idea how to do what you desire.

http://www.geocities.com/sqlserverexamples/#dmscript1

-------------------------

Greg Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

katravax Old Hand Points: 353 More actions · Answer 2

exec sp_spaceused 'MYTABLE'

You could also use SELECT COUNT(*) FROM MYTABLE, but that would be very slow if you don't have a no-NULLs nonclustered indexed column on the table. I'd use sp_spaceused.

- Troy King

Michael S. Armentrout Ten Centuries Points: 1178 More actions · Answer 3

Try this:

EXEC sp_MSforeachtable "select '?', count(*) from ?"

Be great!

Mike

Be great!
Michael

Jonathan Matt SSCarpal Tunnel Points: 4027 More actions · Answer 4

Thanks all for the rapid response. You guys are great!

Jonathan

Michael S. Armentrout Ten Centuries Points: 1178 More actions · Answer 5

If you want to put the results into a table:

CREATD TABLE testt(

tab varchar(125),

cnt int)

GO

INSERT INTO testt

EXEC sp_MSforeachtable "select '?', count(*) from ?"

GO

Be great!

Mike

Be great!
Michael