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

15 votes245 views4 answers
Pl sql
SQL
6 votes251 views1 answer
To count number of rows in SQL table
SQL
24 votes246 views5 answers
Sql reset auto increment
SQL
0 vote257 views1 answer
How to retrive the today date sql
SQL
3 votes267 views2 answers
Install mysql powershell
SQL
0 vote609 views1 answer
Sql field equals multiple values
SQL
0 vote261 views1 answer
Update database collation in postgresql
SQL
0 vote266 views1 answer
Hex string sql becomes int64
SQL
4 votes251 views1 answer
Restart for pg_hba.conf file
SQL
1 vote281 views2 answers
Truncate table sqlite
SQL