摘要： 删除重复记录有大小关系时,保留大或小其中一个记录--> --> (Roy)生成測試數據if not object_id('Tempdb..#T') is null drop table #TGoCreate table #T([ID] int,[Name] nvarchar(1),[Memo] nvarchar(2))Insert #Tselect 1,N'A',N'A1' union allselect 2,N'A',N'A2' union allselect 3,N'A',N' 阅读全文