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 vote227 views1 answer
Get sum sqlite android
SQL
-1 vote240 views5 answers
Left join
SQL
0 vote235 views1 answer
How to get nth number in sql
SQL
0 vote220 views1 answer
Compression of dabatase mysqldumo
SQL
-1 vote226 views1 answer
Mysql change database charset and collation
SQL
1 vote211 views1 answer
Psql client write to bash variable
SQL
1 vote215 views2 answers
Rebuild index sql server
SQL
0 vote207 views2 answers
Postgresql get long running queries
SQL
0 vote224 views1 answer
Exectuer myssql .sql
SQL
0 vote214 views1 answer
Mysql disable query caching
SQL