/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 votes189 views1 answer
Oracle transaction commit rollback example
SQL
0 vote202 views1 answer
Sql server change schema of a table
SQL
0 vote245 views1 answer
Capabilities of sql select statements
SQL
2 votes175 views1 answer
Codeigniter print last sql query
SQL
0 vote309 views1 answer
How to get table current identity value in sql server
SQL
0 vote215 views1 answer
Selecting all columns from table sql database
SQL
1 vote254 views1 answer
Drop column if exists sql server
SQL
0 vote194 views1 answer
H2 auto increment and unique
SQL
12 votes193 views1 answer
Script to add new column in table sql
SQL
5 votes211 views4 answers
Start postgres server
SQL