Tunaslut

Here’s a lovely little one that just took me much to long, probably because I’m tired, or having an off day or something:

SELECT [Name]
         [Surname],
         [Address],
         [Telephone],
         [Email]
FROM ATableAboutPeople

See, the error isn’t obvious, because the SQL compiles and runs, but the result set just doesn’t bring back what you expect…..because [Name] is now aliased as [Surname] – all because of a missing comma.
Bollocks!
Hate it when that happens.

Tags:
Topics: Code
Date: Friday, July 16th, 2010 9:58 am