T-SQL 集锦
2012-03-16 16:04 by 河蟹社会, 12 visits, 网摘, 收藏, 编辑
摘要:alter table SubscribeList add id int identity(1,1)select max(id) as id into #t from SubscribeList group by maildelete from SubscribeList where id not in (select id from #t)drop table #talter table SubscribeList drop column id 删除表中重复字段,保留一个. 阅读全文