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 vote156 views1 answer
Sql value exists in column
SQL
7 votes148 views2 answers
Html to react converter
SQL
1 vote148 views1 answer
Sql pick random row
SQL
0 vote166 views1 answer
Hierarchal database table
SQL
0 vote140 views1 answer
Cast for print sql
SQL
2 votes102 views1 answer
Sql group by different columns
SQL
18 votes149 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote151 views1 answer
Apt install sql server
SQL
0 vote142 views1 answer
Add created and updatedAt fields in mysql
SQL
1 vote165 views1 answer
Last 24 HOUR data in mysql
SQL