Create dbo.GotAnyChange

CreateGotAnyChange.sql

USE Pantheon;
GO

DROP TABLE IF EXISTS dbo.GotAnyChange;

CREATE TABLE dbo.GotAnyChange
     (
         GotAnyChangeID int IDENTITY(1, 1),
	 Column1 int,
         Column2 char(1),
         Column3 date,
         Column4 bigint,
         Column5 varchar(50),
         Column6 datetime
     );

INSERT INTO dbo.GotAnyChange
     (   Column1,
         Column2,
         Column3,
         Column4,
         Column5,
         Column6
     )
VALUES
     (0,                    -- Column1 - int
      'A',                  -- Column2 - char(1)
      GETDATE(),            -- Column3 - date
      0,                    -- Column4 - bigint
      REPLICATE('A', 50),   -- Column5 - varchar(50)
      GETDATE()             -- Column6 - datetime
     );

SELECT  *
FROM    dbo.GotAnyChange;