On the contrary, it did compile but it encountered an error when it ran. If you mistyped and put in "Skelect 'B' ..." it would not compile. Conversion failure is a runtime error, in this case because a varchar 'B' can't be converted to int. The compiler doesn't check to make sure you won't run into data type errors.