SA0226 : The usage of ROWGUIDCOL and IDENTITYCOL as column name in DML statements is deprecated |  |
The topic describes the SA0226 analysis rule.
MessageThe usage of ROWGUIDCOL and IDENTITYCOL as column name in DML statements is deprecated
DescriptionThe rule checks T-SQL code for DML statements, which refer rowguid and identity columns using ROWGUIDCOL and IDENTITYCOL names.
The ROWGUIDCOL and IDENTITYCOL names are deprecated and it is recommended to use the $identity and $rowguid instead.
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.
CategoriesDeprecated Features
Additional InformationExample Test ScriptSQL
1declare @table as table(id uniqueidentifier ROWGUIDCOL, id2 int IDENTITY(1,1)) 2 3select rowguidcol, identitycol from @table 4 5select $rowguid, $identity from @table
Analysis Results
| Message | Line | Column | |
|---|---|---|---|
| 1 | SA0226 : The use of ROWGUIDCOL as column name in DML statements is deprecated. Use $rowguid instead. | 3 | 7 |
| 2 | SA0226 : The use of IDENTITYCOL as column name in DML statements is deprecated. Use $identity instead. | 3 | 19 |
See Also