统计sqlserver所有表的行数
摘要:1、select object_name(id),rowcnt from sysindexeswhere indid<2 and objectproperty(id,'ismsshipped')=0 order by rowcnt descobjectproperty(id,'ismsshipped')=0去掉了mssqlserver系统表2、sp_spaceused;可以写一个proced...
阅读全文
posted @
2009-06-19 14:29
晟晟
阅读(561)
推荐(0)