您现在正在浏览：站长之家 >> 数据库 >> 详细内容

MD5算法的T-SQL实现（FOR SQL2000）（二）

时间:2007-11-09 来源:不详作者:迈克DB

　　SELECT @S21 = 5, @S22 = 9, @S23 = 14, @S24 = 20
　　SELECT @S31 = 4, @S32 = 11, @S33 = 16, @S34 = 23
　　SELECT @S41 = 6, @S42 = 10, @S43 = 15, @S44 = 21
　　--====================================
　　DECLARE @a INT
　　DECLARE @b INT
　　DECLARE @c INT
　　DECLARE @d INT
　　DECLARE @AA　　INT
　　DECLARE @BB　　INT
　　DECLARE @CC　　INT
　　DECLARE @DD　　INT

　　SELECT　 @a = 0x67452301
　　　　　　,@b = 0xEFCDAB89
　　　　　　,@c = 0x98BADCFE
　　　　　　,@d = 0x10325476
　　--====================================
　　DECLARE @sRes　　VARCHAR(32)
　　SET @sRes = ''
　　DECLARE @iWordArrayLen　　　　INT
　　DECLARE @iWordArrayCount　　INT

　　DECLARE @tTmp TABLE([ID] INT, [Word] INT)
　　INSERT INTO @tTmp SELECT * FROM dbo.MD5_ConvertToWordArray(@sOrigMess)
　　SELECT @iWordArrayCount=0, @iWordArrayLen = COUNT(*) FROM @tTmp

　　WHILE(@iWordArrayCount < @iWordArrayLen)
　　BEGIN
　　　　SELECT @AA = @a, @BB = @b, @CC = @c, @DD = @d

织梦内容管理系统

　　　　SELECT @a = dbo.MD5_FF(@a, @b, @c, @d, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 0), @S11, 0xD76AA478)
　　　　SELECT @d = dbo.MD5_FF(@d, @a, @b, @c, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 1), @S12, 0xE8C7B756)
　　　　SELECT @c = dbo.MD5_FF(@c, @d, @a, @b, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 2), @S13, 0x242070DB)
　　　　SELECT @b = dbo.MD5_FF(@b, @c, @d, @a, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 3), @S14, 0xC1BDCEEE)
　　　　SELECT @a = dbo.MD5_FF(@a, @b, @c, @d, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 4), @S11, 0xF57C0FAF)
　　　　SELECT @d = dbo.MD5_FF(@d, @a, @b, @c, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 5), @S12, 0x4787C62A)
　　　　SELECT @c = dbo.MD5_FF(@c, @d, @a, @b, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 6), @S13, 0xA8304613)
　　　　SELECT @b = dbo.MD5_FF(@b, @c, @d, @a, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 7), @S14, 0xFD469501) 织梦好，好织梦
　　　　SELECT @a = dbo.MD5_FF(@a, @b, @c, @d, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 8), @S11, 0x698098D8)
　　　　SELECT @d = dbo.MD5_FF(@d, @a, @b, @c, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 9), @S12, 0x8B44F7AF)
　　　　SELECT @c = dbo.MD5_FF(@c, @d, @a, @b, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 10), @S13, 0xFFFF5BB1)
　　　　SELECT @b = dbo.MD5_FF(@b, @c, @d, @a, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 11), @S14, 0x895CD7BE)
　　　　SELECT @a = dbo.MD5_FF(@a, @b, @c, @d, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 12), @S11, 0x6B901122)
　　　　SELECT @d = dbo.MD5_FF(@d, @a, @b, @c, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 13), @S12, 0xFD987193)
　　　　SELECT @c = dbo.MD5_FF(@c, @d, @a, @b, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 14), @S13, 0xA679438E)
　　　　SELECT @b = dbo.MD5_FF(@b, @c, @d, @a, (SELECT [Word] FROM @tTmp WHERE [ID] = @iWordArrayCount 15), @S14, 0x49B40821)