I have been teaching a T-SQL 101 class and for the homework, we asked the students to get all the records where our heroes had a birthdate between 1995 through 1999. I expected something like this:
[…]
Imagine my surprise when one of the students turned in this:
SELECT FirstName, LastName, Birthdate FROM Heroes WHERE Birthdate BETWEEN '1995' AND '1999'When I first saw the query I thought, “There is no way they ran that and it worked.” So I wrote it up and ran it on my data. Guess what? IT RUNS AND RETURNS DATA! I was shocked.
Click through to see what it returns and how that’s not quite right.