A bare THROW passes an error on untouched. A new THROW or a copied RAISERROR message does not. See the proof, plus one semicolon trap.
SQL SERVER – Exporting Query Results to CSV using SQLCMD
A reader on Facebook asked how to export query results to CSV using SQLCMD. It is a very simple command, and I show it with an AdventureWorks2012 example.
SQL SERVER – SSMS Does NOT Print NULL Values
Here is a very interesting question asked on the blog by Karthik. I really liked the question and I would like to discuss this here about SSMS doe snot Print NULL values.
What Is a Star Schema?
A star schema is one fact table surrounded by dimension tables. What facts and dimensions hold, why grain is the decision you cannot undo, why the data repeats on purpose, and a worked example in AdventureWorksDW.
Subtotals and Grand Totals With ROLLUP and GROUPING SETS
Build region, product, and grand totals with ROLLUP, CUBE, and GROUPING SETS, then label subtotal rows and compare plans.
SQL SERVER – Beginning SQL 2012 – Shred XML with the nodes() Method – Abstract from Joes 2 Pros Volume 5
An abstract from Joes 2 Pros Volume 5 that shows how to shred XML into nodes with an XPath and the nodes() method, without OPENXML or numbered handles.
SQL SERVER – Beginning SQL 2012 – Basics of CONVERT FORMAT Function
Basics of the CONVERT FORMAT Function in SQL 2012: compare FORMAT with the older CONVERT tricks and grab just the part of a date you need for reports.