IP Int 转 Char
来源：互联网 发布：淘宝电脑链接转换手机 编辑：程序博客网 时间：2024/06/12 18:53
USE [UILogDB]GO/****** Object: UserDefinedFunction [dbo].[ipBigIntToString] Script Date: 11/09/2011 09:46:05 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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
