Different between Difference ways of giving Alias name

Posted by Mahe under Sql Server on 6/13/2012 | Points: 10 | Views : 2894 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi All,

In Database there are two ways to give Alias name-
by using "as" keyword and without using "as" keyword.
What is the difference between them?
Ex: Say,

1. Select emp_name as EmployeName, emp_dept as EmployeDepartment
From employtable

2. Select emp_name EmployeName, emp_dept EmployeDepartment
From employtable

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Muhsinathk on: 6/13/2012 [Member] Bronze | Points: 25

0	http://stackoverflow.com/questions/2410853/should-i-use-the-keyword-as-when-aliasing-columns-in-sql-server Mahe, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/13/2012 [Member] Bronze | Points: 25

0	http://msdn.microsoft.com/en-us/library/ms187455%28v=sql.90%29.aspx Mahe, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 9/5/2012 [Member] Bronze | Points: 25

0	There is no difference between both statements above. AS is just a more explicit way of mentioning the alias Mahe, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts