/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 vote235 views1 answer
Mysql 3 months ago
SQL
14 votes220 views2 answers
Oracle add attribute to table
SQL
14 votes186 views1 answer
Excel
SQL
0 vote178 views1 answer
Excute raw query
SQL
0 vote194 views1 answer
Python connect microsoft sql server
SQL
0 vote199 views1 answer
How to put is null in where in clause
SQL
0 vote196 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote241 views1 answer
Postgresql remove new line from string
SQL
0 vote176 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote177 views1 answer
Lister les index d'une table oracle
SQL