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

32 votes416 views6 answers
Rename column mysql
SQL
3 votes333 views2 answers
Oracle drop column
SQL
0 vote368 views2 answers
List all constraints in postgres
SQL
17 votes337 views2 answers
Mysql date to string
SQL
18 votes323 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote330 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote298 views2 answers
Into sql
SQL
0 vote347 views1 answer
Sql server pivot rows to columns
SQL
0 vote319 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
12 votes400 views6 answers
Change mysql root password
SQL