<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
INFORMATION_SCHEMA
Items 1 to 7 of 7
Generate Column Metadata
This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.
Read more...
By
Steven Willis
2013/02/12
|
Source:
SQLServerCentral.com
|
Category:
utility
Rating:
|
Discuss
|
Briefcase
|
354 reads
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,278 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,695 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,537 reads
Display rows vertically
A script to view selects of fat rows vertically with columns in alpha order
Read more...
By
Steve McRoberts
2009/10/05
|
Source:
SQLServerCentral.com
|
Category:
select
Rating:
|
Discuss
|
Briefcase
|
1,758 reads
View - Table Usage (Recursive)
Written to explore the table dependencies of a view, especially when the view queries other views.
Read more...
By
Rhett Clement
2009/01/22
|
Source:
SQLServerCentral.com
|
Category:
schema
Rating:
|
Discuss
|
Briefcase
|
930 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
|
11,886 reads
Items 1 to 7 of 7
Tags
t-sql
(2)
administration
(1)
columns
(1)
dependencies
(1)
format
(1)
metadata
(1)
recursive function
(1)
schema
(1)
select
(1)
sql server 2005
(1)
sql server 2008
(1)
top
(1)
unpivot
(1)
utility
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
