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 vote155 views1 answer
Tsql generate rows
SQL
0 vote169 views1 answer
Delete data from database sqlite android
SQL
0 vote173 views1 answer
Sql select min
SQL
0 vote202 views1 answer
Merge clause with inner join
SQL
9 votes186 views3 answers
Where clause sql
SQL
0 vote204 views1 answer
Mysql grant user wildcard database
SQL
1 vote162 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote223 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote167 views1 answer
Call object contructor and call methods of object
SQL
0 vote173 views1 answer
Jdbc sql connection string
SQL