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 vote378 views1 answer
Increase existing date in sql
SQL
17 votes342 views5 answers
Order by sql
SQL
0 vote402 views2 answers
Connect to mysql server mac terminal
SQL
0 vote344 views1 answer
Mysql select where text contains
SQL
0 vote344 views1 answer
Find number of entries sql
SQL
1 vote364 views1 answer
Sql padd let with zeros
SQL
0 vote373 views3 answers
Mysql delete if not in another table
SQL
24 votes351 views4 answers
How to add column sql
SQL
0 vote361 views1 answer
Access mysql database docker container shell
SQL
0 vote391 views1 answer
Sqlite get date only
SQL