SQL Server - select 1 from emp? where we use in realtime?

Asked By siv h on 15-Feb-13 11:23 PM
please suggest me where we use select 1 from emp? select 2 from emp? in realtime.

thanks in advance
Danasegarane Arunachalam replied to siv h on 22-Feb-13 03:45 AM
Hope this helps


blog.sqlauthority.com/2008/02/26/sql-server-select-1-vs-select-an-interesting-observation/
Danasegarane Arunachalam replied to siv h on 22-Feb-13 03:48 AM
This one looks better

http://stackoverflow.com/questions/7171041/what-does-it-mean-by-select-1-from-table