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

0 vote356 views1 answer
Where date major today mysql
SQL
1 vote394 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote345 views1 answer
Get who is hired in month in sql
SQL
1 vote347 views1 answer
Sql server cast date dd/mm/yyyy
SQL
2 votes310 views2 answers
Function in sql
SQL
0 vote342 views1 answer
Starting mysql shell lampp ubuntu
SQL
7 votes327 views1 answer
Postgres base size
SQL
0 vote542 views1 answer
Multiple row join
SQL
0 vote340 views1 answer
Narural join
SQL
0 vote334 views1 answer
Sql contains vs like
SQL