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 vote251 views1 answer
Sql: extract day text from datetime value
SQL
0 vote258 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
5 votes214 views1 answer
Oracle list packages
SQL
0 vote240 views1 answer
Sql decimal to 2 places
SQL
5 votes281 views1 answer
Oracle source query
SQL
-1 vote245 views1 answer
Create view in mysql workbench
SQL
0 vote232 views1 answer
View to table
SQL
0 vote233 views1 answer
Sql shell psql cannot enter password
SQL
0 vote218 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote234 views1 answer
Pgsql is not permitted to log in
SQL