
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2014 10:17 PM
I've got +/- 180 distinct IP Ranges to be imported, and wanted to double check that the syntax hasn't changed with the new 5.x versions-
Is the following example still correct?
INSERT INTO [lansweeperdb].[dbo].[tsysIPLocations]
VALUES ('10000002000', '10000002255', 'CNR', '10.0.2.0', '10.0.2.255'),
('10022009000', '10022009255', 'CNR', '10.22.9.0', '10.22.9.255'),
('10050010000', '10050010255', 'CNR', '10.50.10.0', '10.50.10.255'),
('160131006000', '160131006255', 'CNR', '160.131.6.0', '160.131.6.255'),
('160131056000', '160131056255', 'CNR', '160.131.56.0', '160.131.56.255')
GO
where CNR is the name of the range being defined in this example
Thanks for the verification & if needed, corrections!
Is the following example still correct?
INSERT INTO [lansweeperdb].[dbo].[tsysIPLocations]
VALUES ('10000002000', '10000002255', 'CNR', '10.0.2.0', '10.0.2.255'),
('10022009000', '10022009255', 'CNR', '10.22.9.0', '10.22.9.255'),
('10050010000', '10050010255', 'CNR', '10.50.10.0', '10.50.10.255'),
('160131006000', '160131006255', 'CNR', '160.131.6.0', '160.131.6.255'),
('160131056000', '160131056255', 'CNR', '160.131.56.0', '160.131.56.255')
GO
where CNR is the name of the range being defined in this example
Thanks for the verification & if needed, corrections!
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2014 07:33 AM
Syntax is correct.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2014 01:37 PM
Great!
Thank you!
Thank you!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2014 07:33 AM
Syntax is correct.
