/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 vote193 views1 answer
Select password from user mysql
SQL
7 votes217 views2 answers
Postgres concat
SQL
-1 vote170 views1 answer
Mysql if example
SQL
25 votes323 views6 answers
Change column name mysql
SQL
8 votes205 views2 answers
Update sql server from another table
SQL
0 vote204 views1 answer
Every Derived yable must have its own alias
SQL
0 vote210 views1 answer
Sql ignore
SQL
5 votes191 views1 answer
Sql add column after another
SQL
0 vote193 views1 answer
Heavy table in mysql
SQL
1 vote193 views1 answer
Get last week data in mysql
SQL