纯真ip地址库如何导入sqlserver数据库

广告：

先导入access，只有access可以根据空格分列。

再导入sqlserver.

SELECT address, SUBSTRING(address, 0, CHARINDEX(' ', address)) AS FirstName, SUBSTRING(address, CHARINDEX(' ',address), LEN(address)) AS LastName FROM Ipdata

根据空格分隔address列

UPDATE Ipdata SET address1 = SUBSTRING(address, 0, CHARINDEX(' ', address)),address2=SUBSTRING(address, CHARINDEX(' ',address), LEN(address))

广告：