SQL server中的parsename方法拆分IP地址或比例,本文主要用parsename操作ip字串:
首先了解parsename的用法:
1、SQL server中如何拆分ip地址
2、再或者,如何拆分一个包装比例,比如1:5:30
selectparsename(replace('1:5:30',':','.'),1)
selectparsename(replace('1:5:30',':','.'),2)
执行结果是:5
selectparsename(replace('1:5:30',':','.'),3)
分离出范围ip中的四个数字位 转整
string[] startIPArray = startIP.Split('.');
string[] endIPArray = endIP.Split('.');
……分别转成整型
我们以查找在范围192.0.0.0~192.255.255.255之间的ip地址为条件,具体的sql语句如下:
select * from ip_address_varchar
where(
cast(parsename(ipAddress, 4) as int) between 192 and 192
and cast(parsename(ipAddress, 3) as int) between 0 and 255
and cast(parsename(ipAddress, 2) as int) between 0 and 255
and cast(parsename(ipAddress, 1) as int) between 0 and 255
)