SA0226 : The usage of ROWGUIDCOL and IDENTITYCOL as column name in DML statements is deprecated
The topic describes the SA0226 analysis rule.
The usage of ROWGUIDCOL and IDENTITYCOL as column name in DML statements is deprecated
The 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.
Replace references to ROWGUIDCOL with $rowguid and to IDENTITYCOL with $identity.
The rule has a Batch scope and is applied only on the SQL script.
Rule has no parameters.
The rule does not need Analysis Context or SQL Connection.
Deprecated Features, Bugs
1declare @table as table(id uniqueidentifier ROWGUIDCOL, id2 int IDENTITY(1,1)) 2 3select rowguidcol, identitycol from @table 4 5select $rowguid, $identity from @table
|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|