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 vote377 views1 answer
Doctors appointment
SQL
0 vote356 views2 answers
How to tun mysql on ubunto
SQL
0 vote360 views1 answer
Update and keep original value sql
SQL
1 vote345 views1 answer
Postgresql last element of array
SQL
1 vote352 views1 answer
Alter constraint postgres
SQL
0 vote394 views2 answers
Mysql insert into multiple tables
SQL
0 vote359 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote425 views1 answer
Parent and child link in mysql
SQL
0 vote365 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
10 votes352 views1 answer
Query to find object dependencies in oracle
SQL