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 vote307 views2 answers
Pl sql auto increment
SQL
9 votes292 views3 answers
Pyodbc connect to sql server
SQL
4 votes254 views3 answers
Create database in mySQL
SQL
0 vote284 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote286 views1 answer
Learnxinyminutes sql
SQL
0 vote257 views1 answer
Google cloud sql postgres url example
SQL
1 vote261 views1 answer
Mysql get latest duplicate rows
SQL
0 vote268 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote265 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote265 views1 answer
Do you know sql
SQL