T-SQL

SQL – How to insert new line/line break in string

If you’re building a string using an SQL statement, you can split results with “new lines” using CHAR() to insert...

SQL Query – Find invalid email addresses

As a database administrator one of the important data health checks you can perform is checking that email addresses being...

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...

SQL – How to copy column data to another column

The following SQL statement shows how to copy the data from one column to another. It will replace any existing...

SQL -Find and replace text in string

The following T-SQL for Microsoft  SQL Server shows how to find and replace text in a string. In this example we’ll change...

SQL – How to search with accented characters

The following T-SQL for Microsoft  SQL Server shows how to search for accented text without having to use the accented characters in...

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...

SQL – How to convert line separated text to comma separated

The following T-SQL for Microsoft  SQL Server shows how to  convert line separated text to comma separated text. For example, if we...