/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 vote210 views1 answer
How to find lowest in sql
SQL
1 vote209 views1 answer
Psql import backup file for windows
SQL
0 vote199 views1 answer
Will graphql replace sql
SQL
1 vote179 views1 answer
Set mysql mode global query
SQL
0 vote217 views1 answer
Sql column contains special character
SQL
0 vote178 views1 answer
Output to file mysql
SQL
1 vote184 views4 answers
Sql now
SQL
4 votes194 views2 answers
Mysql select where starts with
SQL
0 vote205 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
3 votes200 views2 answers
Oracle sql select all days between two dates except weekends
SQL