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

Get 5 Hours of FREE PREMIUM Videos:

LearnVisualStudio.NET Free Preview

LearnVisualStudio Premium Videos

dotNetVideos Premium Video Catalog

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 ]
– AS allows you change column name that is displayed and also allows you to group several columns into one

 T-SQL | 
 copy code |
?
 
-- SELECT AS 
-- PURPOSE: AS allows you change column name that is displayed and also allows
--          you to group several columns into one
-- 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><search_condition> ] 
--			[ <group BY> ] 
--			[ HAVING < search_condition > ] 
 
 
CREATE TABLE people(
     ID          int,
     firstname   varchar (20),
     lastname    varchar (20),
     height      int )
 GO
 
 
 
 
 INSERT INTO people (ID, firstname, lastname, height) 
 VALUES (1,  'Paul', 'Revere', 72)
 GO
 
 INSERT INTO people (ID, firstname, lastname, height) 
 VALUES (2,  'John', 'Lennon', 69)
 GO
 
 INSERT INTO people (ID, firstname, lastname, height)
 VALUES (3,  'Steve', 'McQueen', 75)
 GO
 
 INSERT INTO people (ID, firstname, lastname, height) 
 VALUES (4,  'George', 'Washington', 65)
 GO
 
--Show table without using as
 SELECT * FROM people;
 GO
 
-- Using AS to combine columns and to change column headings 
-- Brackets and single quotes can be used when column heading contains spaces
 SELECT firstname + ' ' + lastname AS [Full Name], height as 'Height Inches'
  FROM people; 
 GO
 
 
 drop table people;
 
 GO
 
 
</group></search_condition></table_source>

Sample Output for SELECT AS Example

Related posts:

1. SELECT AND SQL Server Syntax Example: SELECT AND logical operator T-SQL Example SELECT AND SQL Server Syntax Example: SELECT AND logical operator...
2. SELECT ALL SQL Server Syntax Example: SELECT ALL argument T-SQL Example SELECT ALL SQL Server Example: SELECT ALL argument T-SQL Example...
3. Subquery ALL SQL Server Example: Subquery ALL modifier Example Subquery ALL SQL Server Example: Subquery ALL modifier Example...
4. SQL Server 2005 Express Tutorial: (13 Videos) Database mirroring, backup sql server 2005, sql server 2005 replication, sql server standard edition, download sql server 2005, compare sql server, sql server instance Excellent SQL Server 2005 Express series of 13 free videos...
5. VB.NET Sql Parameters Source Code – Insert Statement Source code example that illustrates using SQL parameters with insert...

Related posts brought to you by Yet Another Related Posts Plugin.