blank
SQL Server Tables

Create a SQL Server table

How to create a SQL Server table with a simple query? This basic SQL example creates a table to store Sales data. It is using different data types, such as strings, numeric values, decimal

blank
SQL Server Tables

Modify a SQL Server table

How to modify a SQL Server table ? With the SQL Server Alter Table command, modify an existing table. The ALTER TABLE SQL Server query helps you update an already existing table. The example

blank
SQL Server Tables

Delete a SQL Server table

How to delete a SQL Server table? How to drop a table without checking if the table exists? Assume the object is already in the database. How to delete a SQL Server table from

blank
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.