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 vote250 views1 answer
Postgres foreign key multiple columns
SQL
0 vote202 views1 answer
Initcap in mysql
SQL
2 votes209 views2 answers
Postgresql get table names
SQL
4 votes236 views1 answer
Rename stored procedure in sql server
SQL
0 vote193 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote201 views1 answer
Move table to a different schema
SQL
6 votes202 views2 answers
Where clause in sql
SQL
4 votes182 views1 answer
Oracle show errors compilation
SQL
0 vote238 views1 answer
Mysql date equals to current_date plus days
SQL
3 votes196 views1 answer
Two select sql
SQL