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 vote154 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
-1 vote138 views1 answer
Add column alter table default value
SQL
0 vote144 views1 answer
Java sql insert return id
SQL
0 vote155 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote172 views1 answer
Repeatable read trong sql server
SQL
-3 votes139 views1 answer
Remove spaces sql 2008
SQL
4 votes160 views1 answer
T-sql get duplicate rows
SQL
0 vote94 views1 answer
FindAllBy
SQL
18 votes175 views3 answers
Mysql add column default value
SQL
4 votes161 views2 answers
Float postgres
SQL