Aladdin

摘要： 在几千条记录里,存在着些相同的记录,如何能用SQL语句,删除掉重复的呢?1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录 delete from people where peopleName in (select peopleNam 阅读全文

摘要： using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Diagnostics;namespace Dictionary测试{ class Program { static void Main(string[] args) { //Hashtable的使用 Hashtable ht=new Hashtable(); ht.Add(10141303, "丁小未"); ht.Add(10141301, "陈立"); Conso 阅读全文

摘要： using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace Dictionary测试{ class Program { private const string HXW = "啊阿埃挨哎唉哀皚癌藹矮艾礙愛隘鞍氨咹俺按暗岸胺案肮昂盎凹敖熬翱襖傲奧懊澳芭捌扒叭吧笆疤巴拔跋靶紦耙壩霸罷爸苩柏百擺佰敗拜稗斑癍搬扳般頒板蝂扮拌伴瓣半か絆邦幫梆榜膀綁棒磅蚌鎊傍謗苞胞包褒剝薄雹保堡飽寶菢報暴豹鮑爆杯碑悲卑丠輩褙贔鋇倍狽備憊焙被奔苯夲笨崩繃甭泵蹦迸逼鼻仳鄙筆彼碧蓖蔽畢斃毖幣庇痹 阅读全文