Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Find sp name by text in sql server

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%Foo%' 
    AND ROUTINE_TYPE='PROCEDURE'
    
SELECT OBJECT_NAME(id) 
    FROM SYSCOMMENTS 
    WHERE [text] LIKE '%Foo%' 
    AND OBJECTPROPERTY(id, 'IsProcedure') = 1 
    GROUP BY OBJECT_NAME(id)
    
SELECT OBJECT_NAME(object_id)
    FROM sys.sql_modules
    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%Foo%'    
Comment

SQL Find text in SPs

SELECT OBJECT_NAME(id) 
    FROM SYSCOMMENTS 
    WHERE [text] LIKE '%Foo%' 
    AND OBJECTPROPERTY(id, 'IsProcedure') = 1 
    GROUP BY OBJECT_NAME(id)
Comment

PREVIOUS NEXT
Code Example
Sql :: fatal error: libpq-fe.h: No such file or directory 
Sql :: uninstall mysql ubuntu 
Sql :: oracle nls_date_format 
Sql :: postgresql find biggest table 
Sql :: service postgres status 
Sql :: mysql now format 
Sql :: oracle all tables in schema 
Sql :: apex execute batch job 
Sql :: psql kill pid 
Sql :: mysql group_concat distinct 
Sql :: oracle get current schema 
Sql :: oracle columns in all_tables 
Sql :: how to get yesterday date in mysql 
Sql :: neo4j display all nodes and relationships 
Sql :: how to list columns for particular tables in postgresql 
Sql :: to date oracle with time 
Sql :: mysql get first x characters 
Sql :: oracle list functions 
Sql :: sql server list table sizes 
Sql :: sql drop schema 
Sql :: mysql add days to date 
Sql :: add sequence postgres 
Sql :: oracle create_program 
Sql :: grant lock tables privilege mysql 
Sql :: oracle compile schema 
Sql :: import sql file laravel cmd 
Sql :: oracle drop chain step 
Sql :: describe table mysql 
Sql :: show sqlite column names 
Sql :: dynamics 365 x++ aggregate querybuilddatasource 
ADD CONTENT
Topic
Content
Source link
Name
4+7 =