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.
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.
nodes() Method in SQL Server: Aliases and Row Patterns
The nodes() method turns each element at a path into one row you can query. This post builds a small catalog of books and reviewers, and shows the two alias errors, query() against value(), the singleton rule, how the row pattern decides the rows, and CROSS APPLY for the next level. Every result comes from SQL Server 2025.
Custom Date Format Strings in SQL Server: MM Is Not mm
Custom date format strings tell FORMAT exactly which parts of a date to show. This post compares CONVERT styles with FORMAT, lists the standard and custom letters, and shows the traps: MM against mm, YYYY against yyyy, month names that sort wrong, and a culture that changes with the session. Every result comes from SQL Server 2025.
Cycle Clipboard Ring in SSMS: SQL in Sixty Seconds #045
To cycle clipboard ring entries in SSMS, press Ctrl+Shift+V after a paste. The clipboard ring is most useful when you copy several names, so this post uses T-SQL to build clean column lists and tests the QUOTENAME and STRING_AGG limits that break a paste.






