SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Department_History
(
    DepartmentNumber INT
);
INSERT Department_History (DepartmentNumber)
VALUES (1), (2), (3);

SELECT * FROM Department_History;

DepartmentNumber

1

2

3

ALTER TABLE Department_History ADD FOO INT;

-- This is fine and shows FOO.
SELECT * FROM Department_History;

-- When uncommented, this fails at parse time.
-- INSERT Department_History (DepartmentNumber, FOO) VALUES (4, 5), (6, 7), (8, 9);

DepartmentNumber
FOO

1
null

2
null

3
null

DepartmentNumber	FOO
1	null
2	null
3	null