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 vote147 views1 answer
Mysql where in maintain order
SQL
15 votes157 views5 answers
Select all tables sql
SQL
6 votes176 views3 answers
Mysql change auto_increment start value
SQL
0 vote161 views1 answer
Find how many tables in database sql query
SQL
1 vote135 views3 answers
How to truncate foreign key constraint table
SQL
3 votes127 views3 answers
Concatenation in sql
SQL
0 vote162 views1 answer
Except in sql
SQL
0 vote156 views1 answer
Str_to_date sql server
SQL
7 votes149 views3 answers
Sql set
SQL
0 vote156 views1 answer
SELECT statement to find the specific cell in database table
SQL