select cast(cast(ipaddress as int)/power(2,24)as varchar(3)) +'.'+cast((cast(ipaddress as int)/power(2,16)% 256 )as varchar(3)) +'.'+cast(((cast(ipaddress as int)/256)% 256 )as varchar(3))+'.'+cast((cast(ipaddress as int)% 256 )as varchar(3)) as ipAddress from snmpcollectdata
2081464330 |?
2081464330 |?
2081464330 |?
2081464330 |?right这个函数好像只能对字符型的吧,所以我想把ipAddress转换位字符.
请问:还有其他办法吗?
+'.'+cast(((cast(ipaddress as int)/256)% 256 )as varchar(3))+'.'+cast((cast(ipaddress as int)% 256 )as varchar(3)) as ipAddress from snmpcollectdata