Search stored procedures

Search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'

Source: stackoverflow.com

Search stored procedures

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]%';

Similar codes

2 votes168 views2 answers
Convert_tz mysql
SQL
1 vote172 views1 answer
Oracle select row max date
SQL
15 votes155 views2 answers
How to know the username of postgresql
SQL
0 vote141 views1 answer
Sql server cannot create database diagram
SQL
3 votes205 views1 answer
How to get yesterday date in sql
SQL
-1 vote156 views1 answer
Add bool column in sql
SQL
13 votes178 views3 answers
Sql online code
SQL
-1 vote204 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote146 views1 answer
Psql datestyle
SQL
0 vote136 views1 answer
Mysql select where text contains
SQL