--带类型 select b.name from dbo.syscomments a, dbo.sysobjects b where a.id=b.id and b.xtype='p' and a.text like '%I_Country_C%' order by name
--不带类型,全部搜索 select b.name from syscomments a,sysobjects b where a.id=b.id and a.text LIKE '%I_Country_C%'
--带类型 select b.name from dbo.syscomments a, dbo.sysobjects b where a.id=b.id and b.xtype='p' and a.text like '%I_Country_C%' order by name
--不带类型,全部搜索 select b.name from syscomments a,sysobjects b where a.id=b.id and a.text LIKE '%I_Country_C%'
转载于:https://www.cnblogs.com/itlinghuchong/p/9850469.html