摘要:
/// <summary> /// 验证位身份证 /// </summary> /// <param name="Id">身份证号码</param> /// <returns>是否真实身份证</returns> public static bool CheckIDCards(string Id) { int intLen = Id.Length; long n = 0; if (intLen == 18) { if (long.TryParse(Id.Remove(17), out n) == fals 阅读全文
摘要:
--创建 test 表 ,插入数据CREATE TABLE test(code varchar(50), [values] varchar(10),[count] int)INSERT test SELECT '001', 'aa',1UNION ALL SELECT '001', 'bb',2UNION ALL SELECT '002', 'aaa',4UNION ALL SELECT '002', 'bbb',5UNION ALL SELECT '002& 阅读全文