/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 vote120 views1 answer
Mysql add fields
SQL
0 vote150 views1 answer
How to get table id sequence postgres
SQL
0 vote123 views1 answer
Sql order by number not ordered
SQL
15 votes112 views2 answers
How to drop database name in postgresql
SQL
0 vote113 views1 answer
Get only structure database mysql
SQL
0 vote122 views1 answer
Snap craft
SQL
1 vote117 views1 answer
Postgres regex remove special characters
SQL
6 votes122 views2 answers
Mysql interval 1 day
SQL
0 vote121 views2 answers
How to start postgresql laravel
SQL
0 vote131 views4 answers
User defined function sql
SQL