Actually, "no difference" isn't strictly true.

If you need to do (NOLOCK) as a table hint because you have a high transaction website then getting this wrong and doing:

SELECT * FROM...