Search
 
SCRIPT & CODE EXAMPLE
 

SQL

search text in all sql server stored procedure

SELECT OBJECT_NAME(object_id)
    FROM sys.sql_modules
    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%Foo%'
Comment

PREVIOUS NEXT
Code Example
Sql :: how to get the size of the database in postgresql 
Sql :: mysql reset auto increment value 
Sql :: today minus 15 days postgresql 
Sql :: sql server reset identity 
Sql :: How to select rows with no matching entry in another table? 
Sql :: postgres get columns names 
Sql :: mysql now format 
Sql :: continue in sql 
Sql :: update sql server from another table 
Sql :: turn on foreign keys check mysql 
Sql :: finding last created table mysql 
Sql :: alter table column change data type to text mysql 
Sql :: postgresql blocked on mac 
Sql :: Remove mySQL from ubuntu 20.x 
Sql :: drop all table postgresql 
Sql :: start mysql server by terminal in linux 
Sql :: postgres add not null to existing column 
Sql :: sql script get all stored procedures from database 
Sql :: sql server last executed query 
Sql :: mysql 1 day ago 
Sql :: mysql command line connect 
Sql :: oracle turn off constraint 
Sql :: add primary key constraint in oracle 
Sql :: status mysql 
Sql :: postgres read table structure 
Sql :: group_concat limit mysql 
Sql :: create schema postgres 
Sql :: SELECT User,Host FROM mysql.user; 
Sql :: sql server 2012 query history 
Sql :: mysql date - 1 day 
ADD CONTENT
Topic
Content
Source link
Name
6+4 =