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 vote229 views3 answers
Constraint sql
SQL
6 votes177 views1 answer
Phpmyadmin reset root password
SQL
1 vote143 views1 answer
Oracle character set
SQL
0 vote183 views1 answer
Split string by comma in sql server
SQL
1 vote180 views1 answer
Get rows affected mysql python
SQL
1 vote252 views1 answer
Sql to mongodb query converter
SQL
0 vote191 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote182 views1 answer
Sql select with apostrohpe
SQL
3 votes248 views1 answer
Query less than datetime sql
SQL
0 vote175 views1 answer
Get who is hired in specific month in sql
SQL