What is the difference between following two statements ?
1. SELECT 'DotnetFunda' 'SQL Server'

2. SELECT 'DotnetFunda' = 'SQL Server'

very tricky.thanks.

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)
DotnetFunda
because you have`t specified Column name to Value.






SELECT 'DotnetFunda' = 'SQL Server'

This is the Eye-catcher:

Result is : DotnetFunda
SQL Server


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?






www.tutorialsqlserver.com