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 vote129 views1 answer
Sql server loop over query
SQL
0 vote117 views1 answer
Soql update query
SQL
0 vote123 views1 answer
Express api ith mysql data
SQL
0 vote110 views1 answer
Go install mysql
SQL
1 vote131 views3 answers
Postgresql get difference between two dates
SQL
3 votes120 views2 answers
Sql add year to date
SQL
0 vote131 views1 answer
Netstat -tln mysql
SQL
4 votes114 views1 answer
Sql data types
SQL
-1 vote120 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote133 views1 answer
Finding leap year in sql
SQL