语句如下:
select distinct object_name(id) from syscomments
where id in (select id from sysobjects where type ='P')
and text like '%tablname%'
在SqlServer2008中测试使用无误!其它数据库版本未考证。
语句如下:
select distinct object_name(id) from syscomments
where id in (select id from sysobjects where type ='P')
and text like '%tablname%'
在SqlServer2008中测试使用无误!其它数据库版本未考证。