Click or drag to resize

SA0160 : Deprecated use of @, @@, or names that begin with @@ as Transact-SQL identifiers

The topic describes the SA0160 analysis rule.

Message

Deprecated use of @, @@, or names that begin with @@ as Transact-SQL identifiers

Description

The rule checks for use of @ or @@ or names that begin with @@ as identifiers.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

Design Rules, Naming Rules, Deprecated Features

Additional Information
Example Test Script
SQL
1declare @ as int, @@ as int, @@a bit ,@@b int

Analysis Results

 MessageLineColumn
1SA0160 : Deprecated use of @, @@, or names that begin with @@ as Transact-SQL identifiers.18
2SA0160 : Deprecated use of @, @@, or names that begin with @@ as Transact-SQL identifiers.118
See Also

Other Resources