SQL Server

Display SQL Server date full month name

How to display SQL Server date full month name? Which is to say with the complete month names like January, February, March, April, May, etc. written out in full. This query shows you how to get the full month names from the current date or any other date.   Indeed,

SQL Server

SQL Server Unpivot query from columns to rows

How to use the SQL Server Unpivot query to simply transform your columns in lines? The T-SQL Unpivot built-in function allows you to do it with one single query. In this example, only the six first months of the year are used as columns, namely January to June. But you

SQL Server

Check SQL Server table last update and access

How to check SQL Server table last update and access? Check the last access and update with a simple SQL query? Thanks to SQL Server RDBMS system tables, a query allows you to display the last changes done. We can apply it to any SQL Server table or view, like