Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

?--There is no identity field on CCNRegions table, so no need for set identity scripts
--SET IDENTITY_INSERT Regions ON;
--GO

INSERT INTO Regions (RegionID, RegionCode, RegionName)
VALUES
(1, 1, 'Region 1'),
(2, 2, 'Region 2'),
(3, 3, 'Region 3'),
(4, 4, 'Region 4'),
(5, 5, 'Region 5'), --this is only available to CCN Regions
(6, 6, 'Region 6') --this is only available to CCN Regions

--Turn off ability to insert identities
--SET IDENTITY_INSERT Regions OFF;
--GO