zqwuwei的技术博客

摘要：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 阅读全文