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

8 votes328 views2 answers
Update sql server from another table
SQL
2 votes297 views4 answers
Duplicate record mysql
SQL
1 vote293 views1 answer
Sqlite create index
SQL
3 votes251 views1 answer
Postgresql where current year
SQL
3 votes276 views3 answers
Mysql select table names
SQL
6 votes246 views2 answers
Generate c# class from sql server table
SQL
0 vote295 views1 answer
Sqlplus change user
SQL
18 votes293 views6 answers
Laravel form validation
SQL
0 vote290 views1 answer
Get cpu details sql
SQL
11 votes325 views4 answers
Update row in mysql
SQL