SQL find text in SP

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

Source: stackoverflow.com

Similar codes

1 vote117 views2 answers
Sql server add time to date
SQL
10 votes117 views2 answers
Tsql merge example
SQL
12 votes104 views5 answers
Sql merge
SQL
0 vote112 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote134 views1 answer
Mysql get only the field names in a table
SQL
0 vote113 views1 answer
Drop specific row postgresql
SQL
0 vote115 views1 answer
Sql replace id with name from another table
SQL
0 vote108 views1 answer
How to search query in python3 sqlite3
SQL
4 votes119 views3 answers
How to describe a table in sqlite3
SQL
0 vote117 views1 answer
Sqlite3 get data from table c
SQL