Skip to content
SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it...
Senario You have a ‘datetime’ field in an SQL server database table and need it to automatically use the current...
When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01...
Below you’ll find two ways to search an SQL table column for a case insensitive string. Both examples use the...
SQL Management Studio allows you to open a table in design mode, make changes then generate a “change script”. The...
Problem If you try to use a column alias in a where statement, you receive an error message that reads...
The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th)....
The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3...
The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if...
The following T-SQL statement shows how output the name of a day from a date. For example, 16 March 2019...
There are many commercial tools to help you design and test SQL statements, as well as the execution tests in...
The following T-SQL statement shows how output the name of the month from a date. For example, 16 March 2019...