存储过程中使用的列

.

但是,您可以使用_SCHEMA.ROUTINES程序如果你愿意的话,还有你的定义。

编辑:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%YOUR COLUMN %' 
    AND ROUTINE_TYPE='PROCEDURE'

或者,如果数据库中有多个同名列,则可以使用此选项。

select DISTINCT p.name
from sys.procedures p   
    INNER JOIN sys.sql_dependencies d on p.object_id = d.object_id
    INNER JOIN sys.tables t on t.object_id = d.referenced_major_id
    INNER JOIN INFORMATION_SCHEMA.ROUTINES R ON R.ROUTINE_NAME = p.name
WHERE R.ROUTINE_DEFINITION like '%YOUR COLUMN %' AND t.name = YOURTABLE