Cool Tips‎ > ‎

Data Searching

 

Title

Description

Applicability

 

Find nth Row    

 

Retrieve nth highest or lowest row from a data set.

 

2000, 2005, 2008, 2008R2, 2012

 

 

Search all Tables for a String   

Initially aimed at discovering the scope of a SQL injection attack, but can be used to search for any string in a database.  Includes a cut-down single-table version.

 

 

2000, 2005, 2008, 2008R2, 2012

 

 

Search for all Object References

Search the DB catalog for all code objects (SP, Vw, Fn etc.) that contain the supplied search string.  A simple implementation of grep.

 

 

2000, 2005, 2008, 2008R2, 2012

 

 

 

 

 

 

 

 

 

Comments