/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

3 votes198 views2 answers
Sql not contains
SQL
0 vote162 views1 answer
Join creating duplicate columns sqllite
SQL
1 vote255 views2 answers
Sql example query
SQL
1 vote203 views1 answer
Epoch time converter in snowflake
SQL
0 vote183 views1 answer
ACCEPT nome PROMPT on oracle
SQL
12 votes170 views4 answers
Mysql ifnull
SQL
0 vote167 views1 answer
Cross apply top for each row t1
SQL
4 votes176 views1 answer
Wilayah indonesia sql
SQL
0 vote201 views2 answers
What is 1=2 in sql
SQL
3 votes180 views2 answers
How to load files in mysql
SQL