34,575
社区成员
发帖
与我相关
我的任务
分享
convert(bigint,数据)
update tb
set ZIP=PARSENAME(IP,1)
+PARSENAME(IP,2)*POWER(256,1)
+PARSENAME(IP,3)*POWER(256,2)
+PARSENAME(IP,4)*convert(bigint,POWER(256,3))
declare @IP varchar(32)
set @IP='211.211.0.214'
select ZIP=parsename(@IP,4)*cast(1000000000 as bigint)
+parsename(@IP,3)*1000000
+parsename(@IP,2)*1000
+parsename(@IP,1)
ZIP
--------------------
211211000214
(1 row(s) affected)
declare @str varchar(100)
set @str='211.211.0.214'
select PARSENAME(@str,1)*POWER(256,0)+PARSENAME(@str,2)*POWER(256,1)+PARSENAME(@str,3)*POWER(256,2)+PARSENAME(@str,4)*convert(bigint,POWER(256,3))
---结果
--------------------
3553820886
(所影响的行数为 1 行)
select cast(replace('211.211.0.214','.','') as int)
/*
-----------
2112110214
(1 row(s) affected)
*/