更新时间:2023-01-19 22:47:02
您可以使用 PARSENAME 函数如下:
You can use PARSENAME function as following :
with address as(
select '192.168.1.1' as IpAddress
Union
select '192.168.1.2' as IpAddress
Union
select '192.168.1.3' as IpAddress
)
SELECT PARSENAME(IpAddress,4) as first,
PARSENAME(IpAddress,3) as second,
PARSENAME(IpAddress,2) as third,
PARSENAME(IpAddress,1) as fourth,
FROM address
PARSENAME 函数返回对象名称的指定部分.
PARSENAME function returns the specified part of an object name.