Home

SQL Keyword: AS

 

Description

The AS keyword is used in a SELECT statement to specify the caption of a field.

Examples

Here is an example that applies the AS keyword to a field:

USE Exercise;
GO

SELECT EmployeeNumber AS N'Empl #',
	   EmployeeName AS N'Full Name',
	   DateHired AS N'Employed Since',
	   HourlySalary
FROM Employees;
GO

 

 
     
 

Home Copyright © 2009-2013 FunctionX, Inc.