/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

0 vote116 views1 answer
Select count postgres double row count > 1
SQL
0 vote95 views1 answer
Output to file mysql
SQL
0 vote106 views1 answer
Sql query interview questions githu
SQL
18 votes110 views3 answers
Mysql current date
SQL
0 vote117 views1 answer
Mariadb alter table add column if not exists example
SQL
5 votes122 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote121 views1 answer
Compression of dabatase mysqldumo
SQL
5 votes136 views3 answers
Create function in postgresql
SQL
3 votes103 views2 answers
Sql paging query
SQL
1 vote117 views1 answer
Date_part mysql
SQL