Global variable names begin with an @@ prefix. : Variable « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. Variable

5> Create table Eq (EqId int identity(1,1),
6>                 Make varchar(50),
7>                 Model varchar(50),
8>                 EqTypeId int)
9> GO
1>
2> Declare @intEqId int
3>      Insert into Eq(Make, Model, EqTypeId)
4>      Values ('ACME', 'Turbo', 2)
5>      Select @intEqId = @@identity
6> GO

(1 rows affected)
1>
2>
3>
4> drop table Eq;
5> GO
1>