The AS keyword is used in these contexts:
SELECT Statement
CREATE VIEW Statement
CREATE PROCEDURE Statement