SELECT
p.name AS ProcedureName,
m.definition AS ProcedureDefinition
FROM sys.procedures AS p
INNER JOIN sys.sql_modules AS m ON p.object_id = m.object_id
WHERE m.definition LIKE '%字段名%'
ORDER BY p.name;

SELECT DISTINCT o.name AS ProcedureName
FROM sysobjects o
INNER JOIN syscomments s ON o.id = s.id
WHERE o.xtype = 'P'
AND s.text LIKE '%字段名%';

SELECT
t.name AS TriggerName,
OBJECT_NAME(t.parent_id) AS TableName,
m.definition AS TriggerDefinition
FROM sys.triggers t
INNER JOIN sys.sql_modules m ON t.object_id = m.object_id
WHERE m.definition LIKE '%字段名%'
ORDER BY t.name;

SELECT
t.name AS TriggerName,
m.name AS TableName,
OBJECT_NAME(t.parent_id) AS ParentTable
FROM sys.triggers t
INNER JOIN sys.tables m ON t.parent_id = m.object_id
WHERE EXISTS (
SELECT 1 FROM sys.sql_modules
WHERE object_id = t.object_id
AND definition LIKE '%字段名%'
)
ORDER BY t.name;

-- 查詢存儲(chǔ)過程
SELECT
'存儲(chǔ)過程' AS ObjectType,
p.name AS ObjectName,
NULL AS TableName,
m.definition AS ObjectDefinition
FROM sys.procedures p
INNER JOIN sys.sql_modules m ON p.object_id = m.object_id
WHERE m.definition LIKE '%字段名%'
UNION ALL
-- 查詢觸發(fā)器
SELECT
'觸發(fā)器' AS ObjectType,
t.name AS ObjectName,
OBJECT_NAME(t.parent_id) AS TableName,
m.definition AS ObjectDefinition
FROM sys.triggers t
INNER JOIN sys.sql_modules m ON t.object_id = m.object_id
WHERE m.definition LIKE '%字段名%'
ORDER BY ObjectType, ObjectName;

--查詢存儲(chǔ)過程
SELECT
p.name AS ProcedureName,
m.definition AS ProcedureDefinition
FROM
sys.procedures p
JOIN
sys.sql_modules m ON p.object_id = m.object_id
WHERE
m.definition LIKE '%@VariableName%'
--查詢觸發(fā)器：
SELECT
t.name AS TriggerName,
m.definition AS TriggerDefinition
FROM
sys.triggers t
JOIN
sys.sql_modules m ON t.object_id = m.object_id
WHERE
m.definition LIKE '%@VariableName%'