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

9 votes102 views3 answers
Mysql show table column full description
SQL
1 vote99 views2 answers
Grab part of a string sql
SQL
0 vote109 views1 answer
We are intrested to work with your organization
SQL
24 votes117 views6 answers
Alter table name sql
SQL
1 vote112 views2 answers
Sql server concat string and int
SQL
2 votes100 views1 answer
Pandas to sql index
SQL
1 vote103 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote97 views1 answer
Postgres call view
SQL
0 vote101 views2 answers
Mysql update two tables at once
SQL
2 votes113 views1 answer
Mariadb select multiple rows into one column
SQL