Using Common Table Expressions in SQL Server 2005
Pretty cool stuff:
-- Common Table Expressions example:
WITH tblDBs AS
(
SELECT COUNT(*) AS [Number of Databases] FROM sysdatabases
),
tblTables AS
(
SELECT COUNT(*) AS [Number of Tables] FROM sysobjects WHERE xtype = 'U'
),
tblColumns AS
(
SELECT COUNT(*) AS [Number of Columns] FROM syscolumns
)
SELECT * FROM tblDBs db, tblTables, tblColumns;
Results from my DB:
Number of Databases Number of Tables Number of Columns
------------------- ---------------- -----------------
23 6 11258
(1 row(s) affected)
No comments:
Post a Comment