From TechRepublic.com:
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:
Post a Comment