DBCC CHECKIDENT('db_name', RESEED, -1539281036)

CREATE TABLE [dbo].[TableA](
[ID] [bigint] IDENTITY(-2147483648,1) NOT NULL,
[ColumnA] [int] NOT NULL,
[ColumnB] [int] NOT NULL,
[ColumnC] [int] NOT NULL,
[ColumnD] [int] NOT NULL,
[ColumnE] [int] NOT NULL,
[ColumnF] [int] NOT NULL,
[ColumnG] [int] NOT NULL,
[ColumnH] [int] NOT NULL,
[ColumnI] [int] NOT NULL,
[ColumnJ] [int] NOT NULL,
[ColumnK] [int] NOT NULL,
[ColumnL] [int] NOT NULL,
[ColumnM] [int] NOT NULL,
[ColumnN] [int] NOT NULL,
[ColumnO] [int] NOT NULL,
[ColumnP] [int] NOT NULL,
[ColumnQ] [int] NOT NULL,
[ColumnR] [int] NOT NULL,
[ColumnS] [varchar](100) NULL,
[ColumnT] [varchar](100) NULL,
[ColumnU] [int] NULL,
[ColumnV] [varchar](50) NULL,
[ColumnW] [varchar](100) NULL,
[ColumnX] [datetime] NOT NULL,
[ColumnY] [datetime] NOT NULL,
[ColumnZ] [int] NULL,
[ColumnAA] [bigint] NULL,
[ColumnBB] [bigint] NULL,
CONSTRAINT [PK_TableA] PRIMARY KEY NONCLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PK_TableA] ADD  DEFAULT (getdate()) FOR [ColumnX]
GO

ALTER TABLE [dbo].[PK_TableA] ADD  DEFAULT (getdate()) FOR [ColumnY]
GO