Skip to content
If you’re building a string using an SQL statement, you can split results with “new lines” using CHAR() to insert...
When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01...
As a database administrator one of the important data health checks you can perform is checking that email addresses being...
Problem If you try to use a column alias in a where statement, you receive an error message that reads...
The following SQL statement shows how to copy the data from one column to another. It will replace any existing...
The following T-SQL for Microsoft SQL Server shows how to search for accented text without having to use the accented characters in...
The following T-SQL for Microsoft SQL Server shows how to convert line separated text to comma separated text. For example, if we...
The following T-SQL for Microsoft SQL Server shows how to find and replace text in a string. In this example we’ll change...
There are many commercial tools to help you design and test SQL statements, as well as the execution tests in...