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')
好的程序员,他们删掉的代码,比留下来的还要多很多。