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

0 vote172 views1 answer
Arithmetic expression in sql
SQL
1 vote179 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote195 views1 answer
How to find total working hour in sql
SQL
0 vote192 views1 answer
Query by column for substring sql
SQL
0 vote183 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote187 views1 answer
Mysql locate
SQL
0 vote178 views1 answer
Sql count total by foreign key
SQL
8 votes210 views1 answer
Mysql limit rows
SQL
0 vote183 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote173 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL