Jump to content

[SOLVED] help with simple insert


knowram

Recommended Posts

I am new to mssql and am trying to move my info from a mysql database to a mssql database. I have just about everything figured out but the INSERT INTO part. what do you used to separate rows. Here is what I have so far

 

INSERT INTO Associa_Networkinfo (Member_Company, Office, Address, Domain, Network_Connection, Device_Name, Serial_Number, Device_Type, Interface, IP_Address, Mask, IAF, Description) VALUES 
('Community Archives', 'Community Archives - Tucson, AZ', '7580 N. La Cholla Blvd|Tucson|AZ|85741', 'CA', 'Point to Point', 'CA-2821-B-7580', '', 'Router', 'Serial0/0/0|GigabitEthernet0/0.2|', '192.168.255.2|192.168.58.1|', '/30|/24|', '||', 'Router - P2P Link|Router - Data VLAN|'),
('Community Management Corporation', 'CMC - Fairfax, VA (HQ)', '12701 Fair Lakes Circle Suite 400|Fairfax|VA|22033', 'CMC', 'NVPN', 'cmc_main', '', 'Router', 'GigabitEthernet0/0|Serial0/1/0|Serial0/0/0:0.2|Serial0/0/0:0.3|', '172.16.111.254|66.10.156.142|192.168.254.9|192.168.254.1|', '/24|/30|/30|/30|', '|1138940|||', 'Router - Data VLAN|Router - NVPN Link|Router - P2P Link|Router - P2P Link|');

 

And I am getting an error on , between the rows.

 

Thanks for the help

Link to comment
Share on other sites

  • 3 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.