SQL Server 2022

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

CREATE TABLE [dbo].[Champ]
(
    [ChampID] [bigint] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](250) NOT NULL,
    [DateOfBirth] [datetime] NOT NULL,
    [CreateTSO] [datetimeoffset](7) NOT NULL CONSTRAINT [DF_Champ_CreateTSO] DEFAULT (SYSDATETIMEOFFSET()),
    [NumWins] [bigint] NULL
)
INSERT INTO Champ(Name, DateOfBirth, NumWins)
VALUES('TestDummy', '1911/12/11', 0)
1 rows affected

SELECT * FROM [dbo].[Champ]


ChampID
Name
DateOfBirth
CreateTSO
NumWins


1
TestDummy
1911-12-11 00:00:00.000
2024-09-26 17:05:14.9062791 +00:00
0


BEGIN TRANSACTION

ALTER TABLE Champ 
    ADD CONSTRAINT DF_Champ_NumWins DEFAULT 0 FOR NumWins
  
INSERT INTO Champ(Name, DateOfBirth)
VALUES('TestDummy', '1911/12/11')

  ROLLBACK

  
INSERT INTO Champ(Name, DateOfBirth)
VALUES('TestDummy', '1911/12/11')

SELECT * FROM Champ    -- last ID now 10002


ChampID
Name
DateOfBirth
CreateTSO
NumWins


1
TestDummy
1911-12-11 00:00:00.000
2024-09-26 17:05:14.9062791 +00:00
0

10002
TestDummy
1911-12-11 00:00:00.000
2024-09-26 17:05:15.5624743 +00:00
null

ChampID	Name	DateOfBirth	CreateTSO	NumWins
1	TestDummy	1911-12-11 00:00:00.000	2024-09-26 17:05:14.9062791 +00:00	0
10002	TestDummy	1911-12-11 00:00:00.000	2024-09-26 17:05:15.5624743 +00:00	null