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 vote178 views1 answer
Mysql terminal run sql file
SQL
0 vote186 views2 answers
How covert into int in maria db
SQL
0 vote162 views1 answer
Difference between 2 query results sql server
SQL
0 vote160 views1 answer
How much table store postgres
SQL
0 vote198 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote179 views1 answer
How to insert multiple rows in mysql using laravel
SQL
4 votes175 views1 answer
Oracle delete last row
SQL
0 vote198 views1 answer
"Hello User Name"
SQL
3 votes221 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
1 vote165 views1 answer
Sql comment header
SQL