Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
#SQLServer 46
SQL Server 44
SSRS EXPERT 41
BI 36
#BI 33
brh 28
SSIS BEST PRACTICES 23
TSQL 19
MS BI STACKS 18
SSRS 17

Archive · View All
March 2011 24
July 2011 17
February 2011 15
April 2010 13
June 2011 11
May 2011 11
April 2011 11
July 2010 11
March 2010 8
December 2011 7

Find which procedures contain text string

Feb 2 2011 1:27AM by Sherry Li   

Very often, we know the table name, but do not know which procedure populates the table (assuming that it’s a stored procedure that does that, not a SSIS package).

Use this simple query against the INFORMATION_SCHMEA.ROUTINES:

select    specific_catalog 
,        specific_schema 
,        routine_name 
,        routine_type 
,        routine_definition 
,        created 
,        last_altered 
from    INFORMATION_SCHEMA.ROUTINES 
where    routine_definition like ‘%myTableNameString%’

Tags: SQL CHALLENGE,


Sherry Li
14 · 12% · 3827
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]