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 vote209 views1 answer
Mysql workbench primary key
SQL
9 votes220 views1 answer
Alter table column change data type to text mysql
SQL
0 vote225 views1 answer
Sql log file inof
SQL
0 vote239 views1 answer
How to update date value in sql
SQL
1 vote192 views1 answer
Copy postgres table from one schema into another
SQL
0 vote252 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote248 views1 answer
Mysql c commands
SQL
1 vote193 views1 answer
Truncate left characters mysql
SQL
1 vote198 views1 answer
Postgresql transaction discard all
SQL
0 vote231 views1 answer
Returning with sqlalchemy
SQL