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 vote162 views1 answer
Influxdb list all tags for a measurement
SQL
8 votes158 views4 answers
Postgresql server restart
SQL
0 vote163 views1 answer
Pl sql search in all packages
SQL
7 votes134 views3 answers
Sql get last inserted row
SQL
2 votes144 views3 answers
Sql delete duplicate
SQL
19 votes139 views6 answers
Sql create table
SQL
3 votes136 views1 answer
Select count from table mysql
SQL
1 vote154 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote127 views1 answer
Join first name and last name sql
SQL
1 vote138 views2 answers
Mysql extract month
SQL