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

3 votes208 views2 answers
Sql end of month
SQL
0 vote199 views1 answer
MySQL import data from large CSV file
SQL
2 votes195 views1 answer
Get first n letter of department name in sql
SQL
1 vote203 views1 answer
Sql select whole row max column
SQL
0 vote217 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote182 views1 answer
Sql python hwo to pass a list in paramerter
SQL
2 votes189 views1 answer
Sql count having
SQL
7 votes192 views1 answer
Connect mysql docker
SQL
0 vote185 views1 answer
Table values functions in SQL
SQL
5 votes229 views2 answers
Functions
SQL