SQL Server stored procedure

Alter a SQL Server stored procedure

How to alter an existing stored procedure in a SQL Server database? Simply use the alter command instead of the create command one to modify an existing SQL procedure. In this example let’s add

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.