SA0235 : Consider using the AS keyword to specify a column alias instead of the column_alias = expression syntax |
 |
The topic describes the SA0235 analysis rule.
MessageConsider using the AS keyword to specify a column alias instead of the column_alias = expression syntax
DescriptionThis rule checks T-SQL script for use of column_alias = expression syntax.
While the assignment operator syntax is legal, the AS keyword syntax is recommended and is SQL ANSI standard.
ScopeThe rule has a Batch scope and is applied only on the SQL script.
ParametersRule has no parameters.
RemarksThe rule does not need Analysis Context or SQL Connection.
CategoriesDesign Rules, Code Smells
Additional InformationThere is no additional info for this rule.
Example Test ScriptSQL
1-- OK 2SELECT au_id+au_id AS alias_for_col 3FROM dbo.authors 4 5-- OK 6SELECT au_id+au_id AS [alias_for_col] 7FROM dbo.authors 8 9-- OK 10SELECT au_id+au_id AS "alias_for_col" 11FROM dbo.authors 12 13-- OK 14SELECT au_id+au_id AS 'alias_for_col' 15FROM dbo.authors 16 17-- OK 18SELECT column_alias=expression 19FROM dbo.authors 20 21-- column_alias = expression syntax is used here, but ignored, because all rules at the violation line are suppressed. 22SELECT alias_for_col=au_id+au_id, au_id --IGNORE:*(LINE) 23FROM dbo.authors 24 25 26-- Deprecated alias syntax is used here. Reported by SA0008 27SELECT 'alias_for_col'=au_id+au_id 28FROM dbo.authors 29 30DECLARE @variable int 31SELECT @variable = 1
Analysis Results
| Message | Line | Column | |
|---|---|---|---|
| 1 | SA0235 : Consider using the AS keyword to specify a column alias instead of the column_alias = expression syntax. | 18 | 23 |
See Also