如何在 SQL Server 程序/触发器中查找文本? [英] How to find a text inside SQL Server procedures / triggers?

问题描述

我有一个会改变的链接服务器.一些过程像这样调用链接服务器:[10.10.100.50].dbo.SPROCEDURE_EXAMPLE.我们有触发器也在做这种工作.我们需要找到所有使用[10.10.100.50]的地方来改变它.

I have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have triggers also doing this kind of work. We need to find all places that uses [10.10.100.50] to change it.

在 SQL Server Management Studio Express 中，我没有在 Visual Studio 中找到在整个数据库中查找"这样的功能.特殊的 sys-select 能帮我找到我需要的吗?

In SQL Server Management Studio Express, I didn't find a feature like "find in whole database" in Visual Studio. Can a special sys-select help me find what I need?

推荐答案

这里是我在系统上用来查找文本的过程的一部分....

here is a portion of a procedure I use on my system to find text....

DECLARE @Search varchar(255)
SET @Search='[10.10.100.50]'

SELECT DISTINCT
    o.name AS Object_Name,o.type_desc
    FROM sys.sql_modules        m 
        INNER JOIN sys.objects  o ON m.object_id=o.object_id
    WHERE m.definition Like '%'+@Search+'%'
    ORDER BY 2,1

这篇关于如何在 SQL Server 程序/触发器中查找文本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！