用tsql将mssql中用户的密码用md5加密

《用tsql将mssql中用户的密码用md5加密》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、用TSQL将MSSQL中用户的密码用MD5加密数据据中有三十多万条记录，因是早期的数据据格式，密码全部是采用明文记录的，现要将所有的密码进行MD5加密，如何实现呢?数据库结构示例：idpasswordinfo11125468student1285524ateacher1358iayman…打开企业管理器：在弹出窗口中输入下列代码(红色部分)：/**Name：T-SQLMD5算法实现*/GOSETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSOFFGOIFEXISTS(SELECT*FROMdbo.sysobjectsWHE

2、REid=OBJECT_ID(N'[dbo].[MD5_m_OnBits]')ANDxtypeIN(N'FN',N'IF',N'TF'))DROPFUNCTION[dbo].[MD5_m_OnBits]GO/**Name：MD5_m_OnBits*Description：常数组*/CREATEFUNCTIONdbo.MD5_m_OnBits(@iTINYINT)RETURNSINT--WITHENCRYPTION--不加密ASBEGINDECLARE@iResINTSELECT@iRes=CASE@iWHEN0THEN1--00000000000

3、000000000000000000001WHEN1THEN3--00000000000000000000000000000011WHEN2THEN7--00000000000000000000000000000111WHEN3THEN15--00000000000000000000000000001111WHEN4THEN31--00000000000000000000000000011111WHEN5THEN63--00000000000000000000000000111111WHEN6THEN127--000000000000000000

4、00000001111111WHEN7THEN255--00000000000000000000000011111111WHEN8THEN511--00000000000000000000000111111111WHEN9THEN1023--00000000000000000000001111111111WHEN10THEN2047--00000000000000000000011111111111WHEN11THEN4095--00000000000000000000111111111111WHEN12THEN8191--00000000000

5、000000001111111111111WHEN13THEN16383--00000000000000000011111111111111WHEN14THEN32767--00000000000000000111111111111111WHEN15THEN65535--00000000000000001111111111111111WHEN16THEN131071--00000000000000011111111111111111WHEN17THEN262143--00000000000000111111111111111111WHEN18TH

6、EN524287--00000000000001111111111111111111WHEN19THEN1048575--00000000000011111111111111111111WHEN20THEN2097151--00000000000111111111111111111111WHEN21THEN4194303--00000000001111111111111111111111WHEN22THEN8388607--00000000011111111111111111111111WHEN23THEN16777215--0000000011

7、1111111111111111111111WHEN24THEN33554431--00000001111111111111111111111111WHEN25THEN67108863--00000011111111111111111111111111WHEN26THEN134217727--00000111111111111111111111111111WHEN27THEN268435455--00001111111111111111111111111111WHEN28THEN536870911--00011111111111111111111

8、111111111WHEN29THEN1073741823--00111111111111111111111111111111WHEN3