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






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>








20.2.Variable
20.2.1.Working with Variables
20.2.2.Use right function with a variable
20.2.3.Testing the ISNULL function
20.2.4.SELECT LEFT(@FullName, 5)
20.2.5.Global variable names begin with an @@ prefix.
20.2.6.XML type variable
20.2.7.Varchar type variable
20.2.8.Use if statement to check a variable
20.2.9.A variable can be assigned a value from a subquery
20.2.10.Use aggregate function with variables
20.2.11.Use Local Variables in where clause
20.2.12.A SQL script that uses variables
20.2.13.Local variables used for searches
20.2.14.Pass variable to a user-defined function
20.2.15.Use one variables in like function