First Statements :
SELECT 'DotnetFunda' 'SQL Server'
Result is : DotnetFunda and Sql server is Column Name, here you are specifying column name to value 'DotnetFunda'
If you run SELECT 'DotnetFunda'
Result (No column name)
because you have`t specified Column name to Value.
SELECT 'DotnetFunda' = 'SQL Server'
This is the Eye-catcher:
Result is : DotnetFunda
Here DotnetFunda is the Column Name And SQL Server is the result
Whats happening here actually :
database Engine creating a variable and assigning "SQL Server" As
Value to it as Aliasing it as DotnetFunda, has anybody find these kind of stuff in BOL?