SQL Server

How to install SQL Management Studio 2008 R2

SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it...

• 6

SQL – How to convert datetime to formatted date string dd-mm-yyyy

When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01...

SQL Server – How to set a datetime field to automatically use current date/time

Senario You have a ‘datetime’ field in an SQL server database table and need it to automatically use the current...

SQL – SELECT query where case insensitive and wildcard

Below you’ll find two ways to search an SQL table column for a case insensitive string. Both examples use the...

SQL Management Studio – How to generate change scripts

SQL Management Studio allows you to open a table in design mode, make changes then generate a “change script”. The...

T-SQL – How to output day name from date

The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019...

T-SQL – How to use where filter with column alias

Problem If you try to use a column alias in a where statement, you recieve an error message that reads...

T-SQL – How to output ordinal number – 1ST 2ND 3RD 4TH

The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3...

SQL – Quick and easy way to performance test SQL statements

There are many commercial tools to help you design and test SQL statements, as well as the execution tests in...

T-SQL – How to reset auto increment to 1

The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if...

T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH

The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th)....

T-SQL – How to output name of month

The following T-SQL statement shows how output the name of the month from a date. For example, 16 March 2019...