查看SQL的字段在哪些Stored Procedure中有出现
SQL:
declare @i varchar(100)
select @i = '%FieldName%'
select distinct b.name
from syscomments a, sysobjects b
where a.id = b.id and patindex(@i,a.text) > 0
order by b.name
Go
查看SQL的字段在哪些Stored Procedure中有出现
SQL:
declare @i varchar(100)
select @i = '%FieldName%'
select distinct b.name
from syscomments a, sysobjects b
where a.id = b.id and patindex(@i,a.text) > 0
order by b.name
Go