Archives
-
Upgrading a Windows MySQL instance from 5.1 to 8.x
I've got a very old instance of MySQL kicking around (5.1.73 - released in December 2013) that's due for an upgrade. It's actually relatively newly created as it was installed using the Web …
-
Don't store monetary values as doubles
It's something that everyone should know, but apparently not...
I had an issue raised by a user recently for a piece of software that I inherited where they were being told that EUR 31,995.27 was …
-
TIL: You can use column aliases in an ORDER BY clause
This is almost certainly something a lot of other people know, but I've somehow managed to not learn it in the many (many!) years of using SQL Server that I have under my belt...
You can use the …
-
Ignoring parameters that haven't been specified in a SQL query
I answered a question on Stackoverflow today that was looking to cater for having parameters to the query that aren't always required, i.e.
The report has three parameters, Sales Id, Start Date and …