deepikamm (1/6/2011)
why do people make use of "select x" instead of "select columnname"?
Errr, they don't. Select x is only possible if there's a column called x, otherwise it will throw an error.
Can you explain clearer what you're asking about?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability