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