SQL server之IP地址计算
DECLARE @ip AS VARCHAR(15) = '1.0.0.0'
-- 将IP地址转换为整数
DECLARE @ipInt AS INT =
(CAST(PARSENAME(@ip, 4) AS INT) * POWER(256, 3)) +
(CAST(PARSENAME(@ip, 3) AS INT) * POWER(256, 2)) +
(CAST(PARSENAME(@ip, 2) AS INT) * POWER(256, 1)) +
CAST(PARSENAME(@ip, 1) AS INT)
-- 计算IP减1的整数值
DECLARE @ipMinusOneInt AS INT = @ipInt- 1
-- 将整数值转换回IP地址
DECLARE @ipMinusOne AS VARCHAR(15) =
CAST((@ipMinusOneInt / POWER(256, 3)) AS VARCHAR) + '.' +
CAST(((@ipMinusOneInt % POWER(256, 3)) / POWER(256, 2)) AS VARCHAR) + '.' +
CAST(((@ipMinusOneInt % POWER(256, 2)) / POWER(256, 1)) AS VARCHAR) + '.' +
CAST(((@ipMinusOneInt % POWER(256, 1))) AS VARCHAR)
SELECT @ipMinusOne AS [IP Minus One]
本文来自博客园,作者:小康0,转载请注明原文链接:https://www.cnblogs.com/z13753176959/p/17867906.html
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步