--select string using in procedure
select b.name, a.text from syscomments a left join sysobjects b on b.id=a.id
where b.xtype='P' and a.text like '%USP_FOUNDATIONUPDATE%'
--select columns name
select b.name as Table1, a.name as Columns1,a.type from syscolumns a left join sysobjects b on b.id=a.id
where b.xtype='u' and a.name like '%season%'
--select table name
select name from sysobjects where xtype='u' and name like '%habit%'
--select string using in function
select b.name, a.text from syscomments a left join sysobjects b on b.id=a.id
where b.xtype='fn' and a.text like '%Fn_GetIR%'
--select string using in view
select b.name, a.text from syscomments a left join sysobjects b on b.id=a.id
where b.xtype='V' and a.text like '%vw_species%'
转载于:https://www.cnblogs.com/Aaron-Lee/p/9252966.html
相关资源：JAVA上百实例源码以及开源项目
