Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Create dbo.GotAnyChange
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment