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...
SQL Management Studio allows you to open a table in design mode, make changes then generate a “change script”. The...
Below you’ll find two ways to search an SQL table column for a case insensitive string. Both examples use 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 statement shows how output the name of a day from a date. For example, 16 March 2019...
The following T-SQL shows how to reset a tables identity auto increment back to 1. This may be useful if...
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...