/SQL/Find string in stored procedure sql server

Find string in stored procedure sql server

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%strHell%'

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 vote106 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
16 votes135 views4 answers
Find duplicates mysql
SQL
33 votes108 views2 answers
Postgres how to add field created at
SQL
3 votes116 views1 answer
Créer une table sql
SQL
0 vote118 views1 answer
How to install sql in anaconda
SQL
1 vote135 views2 answers
One to one and one to many relationship
SQL
12 votes136 views1 answer
Run mysql instance in docker
SQL
0 vote116 views2 answers
Auto increment column in mysql query results
SQL
2 votes114 views1 answer
Mysql query unique column
SQL
0 vote123 views1 answer
Rename view mysql
SQL