create_emp.sql

CREATE TABLE Emp
(
ID INT PRIMARY KEY IDENTITY(1, 1)
, FirstName VARCHAR(100)
, MiddleName VARCHAR(100)
, LastName VARCHAR(100)
)

ALTER TABLE dbo.Emp ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)

INSERT dbo.Emp VALUES ('Joey', NULL, 'Tribbiani')
INSERT dbo.Emp VALUES ('Chandler', NULL, 'Bing')
INSERT dbo.Emp VALUES ('Ross', NULL, 'Geller')
INSERT dbo.Emp VALUES ('Monica', NULL, 'Geller')
INSERT dbo.Emp VALUES ('Rachel', NULL, 'Green')
INSERT dbo.Emp VALUES ('Phoebe', NULL, 'Buffay')