Useful SQL
Insert into from a select query in SQL Server
How to write an Insert into query from a Select with SQL Server? There are three solutions for running an INSERT INTO query with a SELECT in SQL Server. The first solution is …
SQL
SQL Server Index
How to list all SQL Server indexes?
How to list all SQL Server indexes? It can be very useful to display all database indexes. Indeed, to have an idea at a glance at how this SQL Server database is optimized …
SQL Server stored procedure
Create a SQL Server stored procedure
How to create a simple SQL Server stored procedure? This example in transact SQL code list all the Customers from the Customers table by using the selection function. This example do not use …
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 …
SQL Server Views
Create a view with SQL Server
How to create a SQL Server view to display specific columns from an existing table? Consider a view as a virtual table defined by a SQL query. It’s a set of columns and …
SQL Server Views
How to delete a SQL Server view?
How to delete a SQL Server view from the database? How to drop a view? For a SQL developer it’s a good practice to have a clean database and remove the unused or …
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 …
SQL Server Strings
Remove line break from text with SQL Server
How to remove SQL Server line break from a text? If you store a string as a variable or a column in SQL Server, then it can contain line breaks. For example, if …
SQL Server
SQL Server table size and disk space
Listing SQL Server table size and disk space can be very convenient especially to analyse the disk usage for each table. Three different ways, but similar are presented here to display SQL Server …
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 …
