Column Alias – SQL Server Syntax Example: Column Alias – T-SQL Example

Column Alias – SQL Server Syntax Example: Column Alias – T-SQL Example Purpose: – Illustrates the SQL Server syntax for the column alias options. SYNTAX: SELECT [ ALL | DISTINCT ] [TOP ( expression ) [PERCENT] [ WITH TIES ] ] column1 AS displayname1, displayname2 = column_name2, column_name3 displayname3 [ INTO new_table ] [ FROM { table_source } [ ,…n ] ] [ WHERE search_condition AND search_condition... [Read More...]