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: 1175 | 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

Bookmark It

< Previous : Where we can use As keyword in Query or what's ...

Next > : What is an alternate way of checking View inside D ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions