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

SELECT AS SQL Server Syntax Example: SELECT AS T-SQL Example Purpose: – Illustrates the SQL Server syntax for the SELECT AS . Syntax: SELECT [ ALL | DISTINCT ] [TOP ( expression ) [PERCENT] [ WITH TIES ] ] column1 AS displayname1, column2 AS displayname2 [ INTO new_table ] [ FROM { table_source } [ ,…n ] ] [ WHERE search_condition AND search_condition ] [ GROUP BY ] [ HAVING search_condition ] –... [Read More...]