如何找到包含 <text> 的存储过程? [英] How do I find a stored procedure containing &lt;text&gt;?

问题描述

我需要在 SQL Server 2008 中搜索包含可能在哪里的存储过程数据库字段的名称或变量名称.

I need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or variable name.

推荐答案

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

<小时>

SELECT OBJECT_NAME(id) 
    FROM SYSCOMMENTS 
    WHERE [text] LIKE '%Foo%' 
    AND OBJECTPROPERTY(id, 'IsProcedure') = 1 
    GROUP BY OBJECT_NAME(id)

<小时>

SELECT OBJECT_NAME(object_id)
    FROM sys.sql_modules
    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%Foo%'

这篇关于如何找到包含 <text> 的存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！