/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

2 votes310 views1 answer
How to get weekday from old date in sql
SQL
2 votes296 views1 answer
How to add where command in update comand with joins
SQL
4 votes350 views1 answer
Postgres delete last row
SQL
0 vote325 views1 answer
How to remove quotes from a string in ssis load file
SQL
11 votes308 views1 answer
Sql insert multiple rows from select
SQL
2 votes304 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote312 views1 answer
Oracle step procedure
SQL
0 vote338 views1 answer
Write SQL in ruby on rails
SQL
0 vote322 views1 answer
Proc sql not in working
SQL
0 vote399 views1 answer
Run docker container with database as rds metabase
SQL