USE [UILogDB]
GO
/****** Object: UserDefinedFunction [dbo].[ipBigIntToString] Script Date: 11/09/2011 09:46:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[ipBigIntToString] ( @ip bigint )
RETURNS CHAR(15)
AS
BEGIN
DECLARE @o1 INT, @o2 INT, @o3 INT, @o4 INT IF @ip > 4294967295
RETURN '255.255.255.255'
IF @ip <= 0 RETURN '0.0.0.0'
SET @o1 = @ip / 16777216
SET @ip = @ip % 16777216
SET @o2 = @ip / 65536
SET @ip = @ip % 65536
SET @o3 = @ip / 256
SET @ip = @ip % 256
SET @o4 = @ip
RETURN CONVERT(VARCHAR(4), @o1) + '.' + CONVERT(VARCHAR(4), @o2) + '.' + CONVERT(VARCHAR(4), @o3) + '.' + CONVERT(VARCHAR(4), @o4)
END
IP Int 转 Char
最新推荐文章于 2022-12-08 15:22:24 发布