/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 vote198 views1 answer
How to create a table in sql stack overflow
SQL
0 vote293 views3 answers
Insert or ignore postgres
SQL
1 vote194 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote190 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
14 votes172 views4 answers
Remove record from table sql
SQL
1 vote182 views1 answer
Create temporal table in sql
SQL
4 votes209 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote214 views1 answer
Sqlite3 not commit
SQL
1 vote177 views1 answer
Access the postgres psql
SQL
1 vote267 views3 answers
Showing all columns in an sqlite table
SQL