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

1 vote148 views1 answer
Oracle index partition
SQL
0 vote141 views1 answer
Postgres statistics
SQL
0 vote131 views1 answer
Commit transaction sql
SQL
15 votes157 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote146 views2 answers
Connect to mysql server mac terminal
SQL
0 vote129 views1 answer
Sql random decimal
SQL
0 vote134 views1 answer
Mysql convert charset
SQL
2 votes152 views1 answer
Docker run postgres locally
SQL
2 votes156 views1 answer
Install postgresql centos 5
SQL
2 votes145 views2 answers
Laravel query builder toSql
SQL