Topics

• Getting started with Microsoft SQL Server
• OVER Clause
• ALTER TABLE
• PIVOT / UNPIVOT
• The STUFF Function
• FOR XML PATH
• Data Types

Examples

• Basic Character Replacement with STUFF()
• Simple PIVOT & UNPIVOT (T-SQL)