/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 vote175 views1 answer
Select from one table where not on the other
SQL
1 vote180 views1 answer
Mysql column start with string
SQL
0 vote177 views1 answer
Date diff sql
SQL
0 vote169 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
5 votes179 views1 answer
Minecraft java port number
SQL
0 vote229 views1 answer
Sparql list all graphs
SQL
19 votes183 views6 answers
Mysql if null
SQL
1 vote181 views2 answers
Drop function in sql
SQL
0 vote166 views1 answer
Sql random decimal
SQL
0 vote176 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL