Skip to content
Senario You have a ‘datetime’ field in an SQL server database table and need it to automatically use the current...
SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it...
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...