目前测试在字段ip不为空的情况,可以正常排序。
select * from iplist_copy
order by
cast(parsename(ip,4) as int),
cast(parsename(ip,3) as int),
cast(parsename(ip,2) as int),
cast(parsename(ip,1) as int)
目前测试在字段ip不为空的情况,可以正常排序。
select * from iplist_copy
order by
cast(parsename(ip,4) as int),
cast(parsename(ip,3) as int),
cast(parsename(ip,2) as int),
cast(parsename(ip,1) as int)