Many readers struggled with my blog post on this, so here it is as a video: a SQL Server Management Studio shortcut to select single row from any table.
How to Add Column at Specific Position in SQL Server
To add column at specific position in SQL Server, you have three tested options, because ALTER TABLE always adds the column last. This post shows a SELECT list, a view for loads and reports, and a full table rebuild. It also explains what the rebuild costs.
SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function
A friend building a captcha had to skip words that read the same backward. Here is a T-SQL script with REVERSE to check if a string is a Palindrome.
Rethrowing Errors With THROW and Keeping the Original Number
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 – 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.
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.