/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 votes117 views2 answers
Mysql add 2 hours
SQL
4 votes160 views2 answers
Postgresql float data type
SQL
0 vote148 views1 answer
Mysql aspas simples
SQL
4 votes158 views1 answer
Postgresql change default value
SQL
2 votes141 views2 answers
Install sqlalchemy
SQL
0 vote138 views2 answers
Which MySQL statement is used to delete data from a database
SQL
2 votes133 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote138 views1 answer
Less mysql display
SQL
0 vote142 views1 answer
How to create a table based on another table in mysql
SQL
0 vote109 views2 answers
Postgresql display subquery as json
SQL