SQL Server Time and Dates

Display full month name from a date

How to display full month name from a date in SQL Server? Which is to say with the complete month names like January, February, March, April, May, etc. written out in full. This query shows

Blue and grey gearwheels image
SQL Server

SQL Server unpivot query example

How to use a SQL Server unpivot query to transform columns to rows? It’s possible with this simple SQL Server UNPIVOT function example. The T-SQL Unpivot function can do it in one single query.

blank
SQL Server management studio

Option to check object existence in scripts

How to add or remove the object existence checks in SQL creation scripts with SQL Server Management Studio? To add dynamically the existence check before generating the create statement for you SQL Objects like tables,