SQL Server查询某个表被哪些存储过程调用
https://www.cnblogs.com/Sungeek/p/11150119.html
1、也可以使用SQL语句通过系统表来查询,where type=P是系统表的意思,如下:
select distinct object_name(id) from syscomments where id in
(select id from sysobjects where type ='P') and text like '%表名%'
https://www.cnblogs.com/Sungeek/p/11150119.html
1、也可以使用SQL语句通过系统表来查询,where type=P是系统表的意思,如下:
select distinct object_name(id) from syscomments where id in
(select id from sysobjects where type ='P') and text like '%表名%'