-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
CREATE TABLE foobar (id INTEGER IDENTITY NOT NULL, val VARCHAR(50), PRIMARY KEY(id))
GO

INSERT INTO foobar(val) VALUES('A')
GO

SET IDENTITY_INSERT foobar ON
GO

INSERT INTO foobar(id,val) VALUES(3,'C')
GO

SET IDENTITY_INSERT foobar OFF
GO

SELECT * FROM foobar
GO

DROP TABLE foobar;
GO
