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 vote269 views1 answer
How to avoid duplicate records in sqlite
SQL
3 votes282 views3 answers
Mysql order by list
SQL
0 vote277 views1 answer
Data structures in sql
SQL
16 votes277 views3 answers
Delete row psql
SQL
0 vote299 views1 answer
Show mysql account privilleges
SQL
1 vote310 views1 answer
Mysql login console
SQL
2 votes264 views1 answer
How to search table name in stored procedure in sql server
SQL
15 votes277 views3 answers
Find duplicate keys in mysql
SQL
0 vote271 views1 answer
Sqlalchemy query return only n results
SQL
3 votes282 views2 answers
Create schema postgres
SQL