/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 vote233 views1 answer
Python sql last insertend
SQL
21 votes234 views3 answers
Sql server search column name in all tables
SQL
3 votes212 views1 answer
Ms sql skip take
SQL
0 vote203 views1 answer
Sql revert migration
SQL
0 vote206 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote224 views1 answer
Duplix print in Smartforms
SQL
7 votes220 views6 answers
Group_concat in mysql
SQL
2 votes211 views1 answer
Mysql sysdate
SQL
0 vote206 views1 answer
Select max salary from each department in sql
SQL
1 vote227 views1 answer
Oracle nvl2
SQL