/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

3 votes358 views2 answers
Create schema postgres
SQL
1 vote344 views1 answer
Oracle activate job
SQL
0 vote338 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote340 views2 answers
Postgresql get last day of month
SQL
7 votes396 views2 answers
Sql remove duplicates based on column
SQL
2 votes374 views1 answer
Dbms transaction (psql)
SQL
0 vote339 views1 answer
Create a PostgreSQL user django on mac
SQL
1 vote338 views1 answer
Oracle check table space
SQL
0 vote332 views1 answer
Systemverilog unique constraint unique values
SQL
4 votes347 views2 answers
Show all database inside postgresql
SQL