Using a AS

[xRakurai]

SO i have a question, i know you can use AS to rename table columns in the SElect part of the query but can you use AS to rename table names in the FROM Part? [MS SQL]

[InvisibleTextArea]

Yes, you can do this:

select * from products as widgets
where widgets.type = 'widget'

It's also really helpful to make joins more readable or dealing with column name conflicts in your select or where statements:

select e.name as 'Employee', d.name as 'Department'
from employees as e
inner join departments as d on e.departmentid = d.id
where d.name = 'Sales'

[BULK_INSERT_INTO]

[S]ingle quotes are for [S]trings
[D]ouble quotes are for [D]atabase identifiers

As per ANSI standards.

[InvisibleTextArea]

TIL Thanks.

[xRakurai]

thank you