純真ip地址庫如何導(dǎo)入sqlserver數(shù)據(jù)庫
發(fā)布時(shí)間：2024/8/10 16:14:52 作者：Admin 閱讀：44
廣告：
先導(dǎo)入access，只有access可以根據(jù)空格分列。
再導(dǎo)入sqlserver.
SELECT address, SUBSTRING(address, 0, CHARINDEX(' ', address)) AS FirstName, SUBSTRING(address, CHARINDEX(' ',address), LEN(address)) AS LastName FROM Ipdata
根據(jù)空格分隔address列
UPDATE Ipdata SET address1 = SUBSTRING(address, 0, CHARINDEX(' ', address)),address2=SUBSTRING(address, CHARINDEX(' ',address), LEN(address))
廣告：
相關(guān)文章
