There are so many usage of AS keyword in Sql Server.
1). We use AS keyword as an alias shortcut name for a table when you have long queries or queries that have joins.
2). Another use is in assigning column names.
3). Creating SP,Views,CTE and Function and so on.
Asked In: Many Interviews |