/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 votes288 views1 answer
Sql online test questions and answers
SQL
2 votes298 views1 answer
Q operator in plsql
SQL
0 vote312 views2 answers
How to install psql in ubuntu
SQL
0 vote290 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote281 views1 answer
Mysql readable output
SQL
1 vote256 views1 answer
Reutrn string after character sql
SQL
0 vote315 views1 answer
Get total and distict row diff in sql
SQL
1 vote267 views1 answer
Truncate left characters mysql
SQL
1 vote266 views1 answer
Oracle convert run duration to number
SQL
0 vote275 views1 answer
Select all tables linked server sql
SQL