SQL Server 2022

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

CREATE TABLE test (
  id INT,
  dt DATETIME2(7) DEFAULT (SYSDATETIME())
);
WITH cte AS (
  SELECT 1 id
  UNION ALL
  SELECT id + 1 FROM cte WHERE id < 100
)
INSERT INTO test (id) 
SELECT id FROM cte;
100 rows affected

SELECT *
FROM test
WHERE id IN (1, 100)


id
dt


1
2023-12-12 20:10:49.5568808

100
2023-12-12 20:10:49.5568808