2013-05-30
--SQL Server 查询表的记录数--one: 使用系统表.SELECT object_name (i.id) TableName, rows as RowCntFROM sysindexes iINNER JOIN sysObjects o ON (o.id = i.id AND o.xType = U )WHERE indid < 2ORDER BY TableName--******************--two: 使用未公开的过程 "sp_MSforeachtable "CREATE TABLE #temp (TableName VARCHAR (255), RowCnt INT)EXEC sp_MSforeachtable ...