/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 vote121 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote129 views1 answer
Sum values by month mariadb
SQL
0 vote112 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote120 views1 answer
Strat with in sql
SQL
1 vote132 views1 answer
Convert varchar to int in sqlite
SQL
3 votes171 views1 answer
How to get yesterday date in sql
SQL
1 vote130 views3 answers
Psql fatal database does not exist
SQL
0 vote129 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
18 votes128 views4 answers
Uninstall mysql on ubuntu
SQL
1 vote174 views4 answers
Alter schema sql
SQL