SQL Server存储过程名称查询
Select OBJECT_NAME(id)
FROM syscomments
Where [text] LIKE "%table_name%"
AND OBJECTPROPERTY(id, "IsProcedure") = 1
GROUP BY OBJECT_NAME(id)
所有使用表名
SQL Server存储过程名称查询
Select OBJECT_NAME(id)
FROM syscomments
Where [text] LIKE "%table_name%"
AND OBJECTPROPERTY(id, "IsProcedure") = 1
GROUP BY OBJECT_NAME(id)
所有使用表名