SQL Find text in SPs

Kevin Tsumura-Dare answered on September 8, 2021 Popularity 8/10 Helpfulness 4/10

answer SQL Find text in SPs

related Find sp name by text in sql server

related SQL find text in SP

SQL Find text in SPs

Comment

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

Popularity 8/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find sql text

Link to this answer
Share Copy Link

Contributed on May 16 2022

Kevin Tsumura-Dare

0 Answers Avg Quality 2/10

Closely Related Answers

Find sp name by text in sql server

Comment

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%'

Popularity 8/10 Helpfulness 10/10 Language sql

Source: Grepper

Tags: find sp sql

Link to this answer
Share Copy Link

Contributed on Jun 14 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

SQL find text in SP

Comment

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 '%[ABD]%';

Popularity 9/10 Helpfulness 10/10 Language sql

Source: stackoverflow.com

Tags: find

Link to this answer
Share Copy Link

Contributed on Sep 08 2021

Selfish Shrike

0 Answers Avg Quality 2/10

SQL Find text in SPs

Contents

More Related Answers

SQL Find text in SPs

Closely Related Answers

Find sp name by text in sql server

SQL find text in SP

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.