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!
output like : title xyz and value 111
Any Guess :
SELECT 0xyz
Could you please explain what is the mechanism it follows.
Could you please tell me where is the explanation part