SQL Server 查询某张表哪些存储过程用到了
SELECT DISTINCT
b.name,
b.type
FROM dbo.syscomments a,
dbo.sysobjects b
WHERE a.id = b.id
AND b.xtype = 'p'
AND a.text LIKE '%表名%'
ORDER BY name
例:查询products表哪些存储过程用到了
SELECT DISTINCT
b.name,
b.type
FROM dbo.syscomments a,
dbo.sysobjects b
WHERE a.id = b.id
AND b.xtype = 'p'
AND a.text LIKE '%products%'
ORDER BY name