DF059: The assignment operator is used to specify a column alias.

The topic describes the DF059 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

The assignment operator is used to specify a column alias.

Description

According to the ANSI SQL standard, it is recommended to use the AS keyword to specify a column alias.

Noncompliant code example

SELECT CustomerName = c.AccountNumber
FROM sales.Customer c
GO

Compliant solution

SELECT c.AccountNumber AS CustomerName
FROM sales.Customer c
GO