/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 vote209 views1 answer
If column value is null then in mysql
SQL
0 vote205 views1 answer
How to import sqlite driver class in java using maven
SQL
4 votes199 views1 answer
Create table if not exist in sqlite
SQL
2 votes194 views1 answer
Mysql how to store lat,lng
SQL
1 vote223 views1 answer
Get current date in pyspark sql
SQL
0 vote252 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
8 votes235 views1 answer
Oracle tablespace datafile max size
SQL
11 votes186 views1 answer
Oracle insert into where
SQL
3 votes226 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote205 views1 answer
Database schema for mcqs type exam in sql
SQL