SELECT TOP 100 Percent sysobjects.name, sysindexes.rows FROM sysindexes with(nolock) JOIN sysobjects with(nolock) ON sysindexes.id = sysobjects.id AND sysobjects.xtype = ‘u‘ WHERE sysindexes.indid in(0, 1) order by rows desc --何问起 hovertree.com
推荐：http://www.cnblogs.com/roucheng/p/GUID.html
原文：http://www.cnblogs.com/roucheng/p/mssqltable.html