Sqlserver查看所有表数据行数，查找包含xxx字符串的SP

--查看所有表数据行数
SELECT c.TABLE_SCHEMA,c.TABLE_TYPE,a.name, b.rows FROM sysobjects AS a 
INNER JOIN sysindexes AS b ON a.id = b.id
INNER JOIN INFORMATION_SCHEMA.TABLES c on a.name=c.TABLE_NAME WHERE (a.type = 'u') AND (b.indid IN (0, 1))
 ORDER BY a.name,b.rows DESC

 

查找包含xxx字符串的SP

select b.name ,a.text from syscomments a,sysobjects b
where
charindex('#bkAmounts',a.text)>0 and
b.id=a.id and b.xtype in('P','TR')