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 vote288 views2 answers
SQL FROM
SQL
0 vote306 views1 answer
How to get nth number in sql
SQL
10 votes294 views1 answer
Oracle dependencies table
SQL
0 vote293 views4 answers
How to connect form to database
SQL
0 vote288 views1 answer
Drop specific row postgresql
SQL
16 votes281 views4 answers
Sort by sql
SQL
0 vote319 views1 answer
Delete a temporary table mysql
SQL
1 vote306 views1 answer
Avg mysql
SQL
1 vote299 views1 answer
Create another table from existing table sql oracle
SQL
19 votes306 views3 answers
How to change column type psql
SQL