The following SQL statement shows how to copy the data from one column to another. It will replace any existing values in the destination column - so be sure to…

The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft SQL server (T-SQL) -- and will not work in MySQL.…

The following steps show how to display a NULL value (a blank value) as a 0. This can be helpful when you need to use the value to perform calculations…

Problem When running a Crystal Report you receive the following error message Division by zero. Solution Before describing how to work around this issue a quick explanation. When you see…

Problem When using a WordPress plugin you receive an error message which reads: The plugin generated 4191 characters of unexpected output during activation. If you notice “headers already sent” messages,…

Problem When using a WordPress plugin you receive an error message which reads: The plugin generated 4191 characters of unexpected output during activation. If you notice “headers already sent” messages,…

The following SQL command can be used in SQL Management Studio to change a column from varchar(x) to varchar(MAX). ALTER TABLE [table] ALTER COLUMN [column] VARCHAR(MAX) NULL Note that the…

Problem When running an SQL view using SQL Management Studio you experience the following message: MSG 8134, Level 16, State 1, Line 2 Divide by zero error encountered. Solution This…

The following guide describes how to create a Crystal Report which check if a field is blank (NULL or empty) and if it is use an alternative field. This could…