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

1 vote313 views1 answer
Sql upsert
SQL
6 votes329 views2 answers
Mysql execute file
SQL
7 votes305 views1 answer
Sql server convert string to date
SQL
0 vote328 views1 answer
Sql query to force the database to be drop
SQL
0 vote323 views1 answer
Exit psql
SQL
0 vote313 views2 answers
Android sqlite query join
SQL
0 vote292 views1 answer
Can we rollback deleted data in sql
SQL
0 vote303 views2 answers
Demmarrer un service mysql teminal cmd
SQL
-1 vote324 views1 answer
Utf8_encode mysql
SQL
0 vote285 views1 answer
Sql python hwo to pass a list in paramerter
SQL