SQL Server 2019

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

CREATE TABLE dbo.SomeTable (ID int IDENTITY(0,-1),
                            SomeInt int);
INSERT INTO dbo.SomeTable (SomeInt)
VALUES(1),(2);
2 rows affected

SELECT *
FROM dbo.SomeTable;

SELECT SCOPE_IDENTITY();

ID
SomeInt

0
1

-1
2

(No column name)

-1

DROP TABLE dbo.SomeTable;