-- 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 noget (
    id INTEGER NOT NULL,
    felt INTEGER DEFAULT 2,
    PRIMARY KEY (id)
); 

INSERT INTO noget VALUES(1,77);
INSERT INTO noget VALUES(2,NULL);
INSERT INTO noget(id) VALUES(3);

SELECT * FROM noget;

DROP TABLE noget;
