廣告：

先導入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))

廣告：