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
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?