/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 votes186 views2 answers
Df to sql pandas sql achemy
SQL
0 vote218 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote174 views1 answer
Sqlite to csv statement
SQL
0 vote192 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote208 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote192 views1 answer
R write csv without index
SQL
20 votes179 views2 answers
Counting in sql
SQL
1 vote213 views1 answer
Postgresql not in
SQL
2 votes229 views4 answers
Mysql select into new table
SQL
14 votes202 views3 answers
How to add default constraint in mysql
SQL