T-SQL Analyzer

# SQL Server Rule: SML022 | | | |----|----| | Assembly | TSQLSmellSCA | | Namespace | TSQLSmellSCA | | Class | TSQLSmellSCA22 | ## Rule Information | | | |----|----| | Id | SML022 | | Friendly Name | Identity value should be agnostic | | Category | CodeSmells | | Ignorable | false | | Applicable Types | Model | ## Description Identity value should be agnostic ### Examples ```sql CREATE PROCEDURE dbo.Sets2 AS SET NOCOUNT ON; SET DATEFORMAT DMY; SET DATEFIRST 1 SET FORCEPLAN ON SET IDENTITY_INSERT dbo.TestTableSSDT On -- SML008, SML009, SML020, SML022 ``` _{^{Generated by a tool}}