Advanced SQL

SQL Pivot

With SQL Server 2005 a lot of new features have been introduced. One of these new features is PIVOT.  What this allows you to do is to turn query results on their side, so instead of having results listed down like the listing below, you have results listed across.

SQL System Tables

Parameters in Procedure and Functions

SQL Objects