摘要：
declare @ipString varchar(128)set @ipString = '192.168.1.89'select cast(PARSENAME (@ipString, 1) as bigint) + cast(PARSENAME (@ipString, 2) as bigint) * 255 +cast(PARSENAME (@ipString, 3) as bigint) * 65025 + -- 65025 = 255^2cast(PARSENAME (@ipString, 4) as bigint) * 16581375 -- 16581375 = 2 阅读全文
posted @ 2011-04-08 16:01 zqwuwei 阅读(308) 评论(0) 推荐(0) 编辑
