--NC65用户密码加密方式为:'U_U++--V' + MD5(用户的CUSERID字段值+密码明文)
SELECT
'U_U++--V'+STUFF(master.dbo.fn_varbintohexstr(HASHBYTES('MD5',CONVERT(VARCHAR(50), cuserid+'密码'))),1,2,'') AS NC65
FROM sm_user
--NC Cloud用户密码加密方式为:'S_S++'+ Base64编码(SHA256(用户的CUSERID字段值+密码明文))
SELECT
'S_S++'+dbo.FnBase64Encode(HASHBYTES('SHA2_256 ',CONVERT(VARCHAR(50), cuserid+'密码'))) AS [NC cloud]
FROM sm_user
03-22
1762
08-21
726
11-16
1333
11-18
527