Time to time crazy things are happening in SQL Server. T-SQL looks like to be easy and rigid language without any options for playing with it like other languages. I will show you that there is still some space where you can do magic and have some fun. Check out this sample query a test on our own. Yes, it will really execute successfully:).
CREATE TABLE [dbo].[SampleTable]
INSERT INTO [dbo].[Sampletable]
SELECT 1, 'Value1'
How that works? Column aliases are ignored in INSERT INTO command so that we can place any funny string there. I think that an error should be raised rather because this lazy behavior can lead to unwanted confusion.