1、打开，下载xp_md5.dll

 2、打开SQL2005数据库，选择master数据库，实行如下语句：

USE master;
EXEC sp_addextendedproc 'xp_md5', 'xp_md5.dll'; --这里写你文件实际位置

 3、实行如下语句

 USE master;
CREATE FUNCTION [dbo].[fn_md5] (@data TEXT)
RETURNS CHAR(32) AS
BEGIN
  DECLARE @hash CHAR(32)
  EXEC master.dbo.xp_md5 @data, -1, @hash OUTPUT
  RETURN @hash
END;

 USE master;

CREATE FUNCTION [dbo].[fn_md5x] (@data IMAGE, @len INT = -1)
RETURNS CHAR(32) AS
BEGIN
  DECLARE @hash CHAR(32)
  EXEC master.dbo.xp_md5 @data, @len, @hash OUTPUT
  RETURN @hash
END;

 --要是实行有问题就一段一段选择实行

 4、打开赤壁数据库，实行如下语句：

 select upper('0x'+master.dbo.fn_md5('test'+'test')); --先实行，将结果复制出来

 INSERT INTO account
                      (id, name, passwd, creatime, usertype)
VALUES     (96, 'test', 0x05A671C66AEFEA124CC08B76EA6D30BB, GETDATE(), 0);

 INSERT INTO users
                      (id, prompt, answer, truename, idnumber, email, mobilenumber, province, city, phonenumber, address, postalcode, gender, birthday, QQ,

passwd2)
VALUES     (96, 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 0, GETDATE(), 'test',
                      0x05A671C66AEFEA124CC08B76EA6D30BB);