T-SQL Friday, 16 February 2018 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 – 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 -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 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 – 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 – 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...
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 – 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 -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 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 – 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 – 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...