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 vote350 views1 answer
Oracle character set
SQL
4 votes384 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote360 views1 answer
Replace content value from old to new sql
SQL
0 vote364 views2 answers
Py sqlite if entry exists
SQL
9 votes340 views1 answer
Oracle get table schema
SQL
4 votes336 views2 answers
DB::transaction
SQL
0 vote383 views1 answer
Sql max of two values
SQL
0 vote369 views1 answer
Insert or update sql firebird
SQL
3 votes362 views1 answer
Start mysql server by terminal in linux
SQL
0 vote336 views1 answer
Heavy table in mysql
SQL