SQL Server 2019

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

CREATE TABLE #t (I int);

INSERT INTO #t (I)
VALUES(1);
1 rows affected

DROP TABLE IF EXISTS #t;
CREATE TABLE #t (I int, D date);

INSERT INTO #t
VALUES(2,GETDATE());
Msg 213 Level 16 State 1 Line 4
Column name or number of supplied values does not match table definition.

SELECT *
FROM #t;


I


1


DROP TABLE #t