Error converting data type varchar to datetime Are you getting the above error? Run the following under your app user. select @@Language, @@Langid If it says us_english then you’re probably hitting errors when parsing dates as DD/MM/YYYY. We can change the default language for a particular user....

Don’t ask me why, but I ALWAYS forget how to select results from an mSQL database where the value is null. It’s just weird. I always try select * from table where colname = null or select * from table where colname = ” But the correct way is to select using IS NULL! select * from table...

This error was the bane of my life for a while, and it was very hard to get a definitive answer as to what was causing it, I hope this saves you some trouble. My website occasionally got large traffic spikes, and at the top of these peaks, I would start to see errors like these: MySQL error #1135: Can’t...

A stored procedure I used as a download script. You pass this procedure a parameter (filename), it checks the database if a record for this exists. If so it increments the record by one. If the record doesnt exist it creates it for you. For this to work I used a table with two columns. filename varchar(255) hits...