/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

20 votes327 views1 answer
Sql change column types
SQL
18 votes319 views6 answers
Drop table if exists
SQL
1 vote322 views1 answer
Get parameter value in mysql trigger
SQL
0 vote335 views1 answer
Helptext in sql
SQL
3 votes366 views1 answer
Oracle sql commit example
SQL
0 vote315 views1 answer
Sum values by month mariadb
SQL
0 vote307 views1 answer
List MySQL Table and Index Size
SQL
6 votes330 views2 answers
Psql load dump
SQL
0 vote324 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote311 views2 answers
Mysql updating multiple column values from array variable
SQL