/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 vote244 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote243 views1 answer
Is not numeric sql
SQL
0 vote239 views1 answer
Mysql create pool
SQL
6 votes258 views2 answers
Mysql 1 day ago
SQL
0 vote253 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote234 views1 answer
How to retrive the today date sql
SQL
0 vote253 views1 answer
Change role postgres
SQL
7 votes241 views3 answers
Convert ansi sql
SQL
0 vote255 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
2 votes253 views1 answer
Flask sqlalchemy boolean field
SQL