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

1 vote186 views1 answer
Type int in mysql maxlenght
SQL
0 vote171 views1 answer
Mysql search multiple tables
SQL
26 votes187 views2 answers
Mysql workbench download
SQL
5 votes186 views3 answers
Sql max value in column
SQL
1 vote190 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote193 views1 answer
Postgresql inline table
SQL
6 votes186 views2 answers
Postgresql database url
SQL
0 vote168 views1 answer
How to connect pgadmin with excel
SQL
0 vote197 views2 answers
Sql server select first day of previous year
SQL
0 vote190 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL