/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 vote244 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote244 views1 answer
Sql quary intervewi question
SQL
7 votes250 views1 answer
Query postgres delete duplicates
SQL
5 votes228 views1 answer
Postgresql functions
SQL
-1 vote235 views1 answer
How to dump .csv file into mysql
SQL
25 votes243 views3 answers
How to use a database to see tables mysql
SQL
0 vote219 views1 answer
How to select only id where is not in column mysql
SQL
0 vote220 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote257 views1 answer
Insert into table with only identity column
SQL
1 vote231 views1 answer
Table information in sql server
SQL