Monday, December 04, 2006

New SQL Server Resources


Understand the effects of NULLs on inner and outer JOINs  This SQL Server tip explains the effects of NULLs, and the different results obtained by inner and outer JOINs.

Turn XML into relational data with OPENXML  XML support has been significantly extended for SQL Server 2005. This article takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.

Software download: SQL Visualizer  SQL Visualizer is a Windows client-based SQL Server database query and management tool designed to make SQL development simpler and more productive. Free to try.

No comments: