SQL Tuesday, 15 July 2014 by How to install SQL Management Studio 2008 R2 SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it... 6 How to generate SQL create table script using phpMyAdmin The following steps show how to create an SQL create script using phpMyAdmin. This can be helpful if you have... SQL – How to convert datetime to formatted date string dd-mm-yyyy When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01... Crystal Reports – Display unique records only The following steps show how to make a Crystal Report show only unique records. This example is using Crystal Reports... 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... SQL – How to count unique values in database The following shows how use a simple SQL statement to create a list of unique values and a count of... SQL – How to concatenate/combine column values into comma separated text string The following SQL statement shows how to combine a column into a single text string – separated by a comma.... How to use a REGEX in an SQL SELECT query The following example shows how to use a regular expression (a regex) to search for information in an SQL database.... SQL – How to get current financial year using SQL The following SQL shows how to get the current financial year using SQL. This assumes that the financial year for... SQL – How to decode HTML entities when using FOR XML PATH When building complicated SQL statements often I will make use of a SELECT – FOR XML PATH statement to concatenate... WordPress – How to use LIKE in WPDB PREPARE SQL statements In WordPress the WPDB class is available for interacting with the database, for example reading or writing data. The PREPARE... 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 remove spaces before and after database values The following SQL can be used to remove leading and trailing spaces from a columns values. Ideally the system that... WordPress – How to use IN in WPDB PREPARE SQL statements In an SQL statement, the IN operator allows you to multiple values in a WHERE clause, for example: SELECT *... 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 select current year from lookup table The following SQL shows how to select a row from a table using the current year as the WHERE condition.... 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 select current financial year from lookup table The following SQL shows how to select a row from a table using the current financial year as the WHERE... MS SQL Server 2008 – How to update value using SELECT results The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft... 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...
How to install SQL Management Studio 2008 R2 SQL Management Studio is the must use tool for SQL database administrators, however every time I’ve needed to install it... 6
How to generate SQL create table script using phpMyAdmin The following steps show how to create an SQL create script using phpMyAdmin. This can be helpful if you have...
SQL – How to convert datetime to formatted date string dd-mm-yyyy When you have a date or datetime column in an SQL database, it will output a value that looks like 2017-01-01...
Crystal Reports – Display unique records only The following steps show how to make a Crystal Report show only unique records. This example is using Crystal Reports...
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...
SQL – How to count unique values in database The following shows how use a simple SQL statement to create a list of unique values and a count of...
SQL – How to concatenate/combine column values into comma separated text string The following SQL statement shows how to combine a column into a single text string – separated by a comma....
How to use a REGEX in an SQL SELECT query The following example shows how to use a regular expression (a regex) to search for information in an SQL database....
SQL – How to get current financial year using SQL The following SQL shows how to get the current financial year using SQL. This assumes that the financial year for...
SQL – How to decode HTML entities when using FOR XML PATH When building complicated SQL statements often I will make use of a SELECT – FOR XML PATH statement to concatenate...
WordPress – How to use LIKE in WPDB PREPARE SQL statements In WordPress the WPDB class is available for interacting with the database, for example reading or writing data. The PREPARE...
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 remove spaces before and after database values The following SQL can be used to remove leading and trailing spaces from a columns values. Ideally the system that...
WordPress – How to use IN in WPDB PREPARE SQL statements In an SQL statement, the IN operator allows you to multiple values in a WHERE clause, for example: SELECT *...
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 select current year from lookup table The following SQL shows how to select a row from a table using the current year as the WHERE condition....
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 select current financial year from lookup table The following SQL shows how to select a row from a table using the current financial year as the WHERE...
MS SQL Server 2008 – How to update value using SELECT results The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft...
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...