01 2012 档案

SQL Server 查询表的记录数
摘要：--one: 使用系统表.SELECT object_name (i.id) TableName, rows as RowCntFROM sysindexes i INNER 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... 阅读全文
posted @ 2012-01-04 10:07 zhjw0996 阅读(761) 评论(0) 推荐(0)