摘要: public string MD5(string str, int code) { if (code == 16) //16位MD5加密(取32位加密的9~25字符) { return System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str, "MD5").ToLower().Substring(8,16); } else//32位加密 { return Syste... 阅读全文
posted @ 2013-12-02 16:10 盛开的雨季 阅读(287) 评论(0) 推荐(0) 编辑
摘要: select a.* from Pair_User a where 1=1 and UPPER(a.UserID) like 'EMH1001%' collate Chinese_PRC_CI_AS_WS and a.UserPassWord=123_BIN二进制排序_CI(CS)是否区分大小写,CI不区分,CS区分_AI(AS)是否区分重音,AI不区分,AS区分_KI(KS)是否区分假名类型,KI不区分,KS区分_WI(WS)是否区分宽度WI不区分,WS区分 阅读全文
posted @ 2013-12-02 13:52 盛开的雨季 阅读(6947) 评论(0) 推荐(0) 编辑