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>