Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-06 : 14:32:51
|
| richard writes "HiI want a query returning 2 columns - 'table_name' and 'number_of_rows'. How hard can it be !!I keep thinking about corrolated subqueries, and how to combine "select name from syscolumns where xtype = 'u' ", with "select count(*) from [name] ".any ideas ?Richard" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-03-06 : 14:32:52
|
How about a script that's already written that does it?
http://www.sqlteam.com/item.asp?ItemID=282 |
 |
|
|
|
|
|
sql 2000 db stats