Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag INFORMATION_SCHEMA Rss

Search for any content tagged information_schema

   Items 1 to 4 of 4   
 

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,329 reads

INFORMATION_SCHEMA.101

Get information about the objects in your database using these ANSI standard, multi-platform views.  Read more...
By Tom Powell 2011/10/04 | Source: SQLServerCentral.com | Category: information_schema
Rating: |  Discuss |   Briefcase | 5,721 reads

Query-generated Column Expressions

A technique from Bill Nicolich that allows you to target columns by data type for the same custom expression and easily build complex queries.  Read more...
By Bill Nicolich 2010/05/25 | Source: SQLServerCentral.com | Category: information_schema
Rating: |  Discuss |   Briefcase | 8,554 reads

Querying the INFORMATION_SCHEMA

Using a macro to query the INFORMATION_SCHEMA  Read more...
By Mike DiRenzo 2008/03/03 | Source: SQLServerCentral.com | Category: information_schema
Rating: |  Discuss |   Briefcase | 12,006 reads
   Items 1 to 4 of 4