What is the Difference between below queries?

Select * from Employee_Master as Emp;
Select * from Employee_Master Emp;

 Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 260 | Points: 40
Answer:

There is no difference between both statements above.
AS is just a more explicit way of mentioning an alias name.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response