SQL Variable usage

gistfile1.sql

USE CurtDev;
GO

DECLARE @id AS int;
--Create new ContentID for every T-Connector part in the Content table
--use last inserted identity value as variable, id
INSERT INTO Content(text, cTypeID)
VALUES    ('Simple plug and play design eliminates the need for cutting or splicing', 2);
SET @id = (SELECT @@IDENTITY);
GO
 
--define a variable to hold contentID from Content
INSERT INTO ContentBridge (catID, partID, contentID)
VALUES(Null, 55027, @id);
GO