cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
esr
Champion Sweeper
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!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Syntax is correct.

View solution in original post

2 REPLIES 2
esr
Champion Sweeper
Great!
Thank you!
Hemoco
Lansweeper Alumni
Syntax is correct.