Browse by Tags

All Tags » alias name » sql server (RSS)
09 September 2008 14:19

Should alias names be preceded by AS? - Part 2

In the Part 1 , I expressed my opinion on having the alias names preceded by the keyword AS Adding to the examples given at the link, consider this example too SELECT 10number , 10.number , 10 number , 10 [number] , 10[number] , 10 as number It gives...
Posted by Madhivanan | with no comments
Filed under: , ,
14 November 2007 12:46

Should alias names be preceded by AS?

If you ask me, I would say Yes When you write select statements and use alias names, always make sure alias names are preceded by the keyword AS . Oherwise you may get results which are unexpected and sometimes difficult to debug. Consider the following...
Posted by Madhivanan | 7 comment(s)
Filed under: ,