Simple Quiz On Sql Server Select statement
If we execute a statement like below, it will throw error:
SELECT xyz Result: Msg 207, Level 16, State 1, Line 1 Invalid column name 'xyz'.
Can you guess what the below statement execution will result and reason for the same? Be frank don’t execute the statement and answer. By the way Today, I came to know about this behaviour only after executing this statement 
SELECT 111xyz
AI embedded SQL Server
Cool B, this is even funnier SELECT 1+1xyz …
How exactly this works?? I’m shell shocked to see this!