I always think this is a really useful thing to know with SQL because it can cause so many issues if someone isn't aware of it.

I've had it explained to...