Today I had the "pleasure" to fix a problem in a customer's SQL server database where some records had wrong values in date fields. The theory is quite simple. Find out which records are affected (there were only 7 of them) and correct the problem with a statement like this: update tablename set datefield='2008-02-14' where … Continue reading Specifying a date for MS SQL Server