--删除完全重复的dindan表记录，已知订单号的情况下;
use db
declare @order nvarchar(50)
declare @autoid int
declare @count int

set @order = '订单号'
select @count = count(*) from dindan where id = @order
if (@count > 0 )
begin
--将指定的订单号记录插入到dindan_cc表里;
select identity(int,1,1) as atid,* into dindan_cc from dindan where id = @order

--删除dindan表里的订单;
delete from dindan where id = @order

select @autoid = min(atid) from dindan_cc

--重装取回一条记录插入到dindan表中;
insert into dindan select [id]
           ,[money1]
           ,[money2]
           ,[money3]
           ,[name1]
           ,[name2]
           ,[taoxiid]
           ,[taoxiname]
           ,[taoxijiage]
           ,[taoxizs]
           ,[time1]
           ,[time2]
           ,[time3]
           ,[bm]
           ,[ren]
           ,[discount]
           ,[payed1]
           ,[payed2]
           ,[payed3]
           ,[payed4]
           ,[payed5]
           ,[time4]
           ,[time5]
           ,[takezs]
           ,[choosezs]
           ,[status]
           ,[clothescount2]
           ,[outside2]
           ,[style]
           ,[payed3time]
           ,[payed4ren]
           ,[payed4time]
           ,[status2]
           ,[status3]
           ,[waiter1]
           ,[waiter2]
           ,[waiter3]
           ,[waiter4]
           ,[bz]
           ,[taketime]
           ,[clothescount]
           ,[outside]
           ,[bz2]
           ,[bz3]
           ,[urgent]
           ,[status4]
           ,[status5]
           ,[waiter5]
           ,[waiter6]
           ,[pinyin1]
           ,[pinyin2]
           ,[waiter7]
           ,[status6]
           ,[phone1]
           ,[phone2]
           ,[status7]
           ,[memberno]
           ,[waiter8]
           ,[time6]
           ,[status8]
           ,[bruncount]
           ,[tichenren1]
           ,[tichenren2]
           ,[tichenren3]
           ,[tichenren4]
           ,[tichenren5]
           ,[send1]
           ,[send2]
           ,[send3]
           ,[datetime4]
           ,[datetime5]
           ,[datetime6]
           ,[waiter12]
           ,[waiter22]
           ,[waiter1rate]
           ,[waiter2rate]
           ,[waiter13]
           ,[waiter14]
           ,[waiter23]
           ,[waiter24]
           ,[waiter12rate]
           ,[waiter13rate]
           ,[waiter14rate]
           ,[waiter22rate]
           ,[waiter23rate]
           ,[waiter24rate]
           ,[ren2]
           ,[renrate]
           ,[ren2rate]
           ,[txtype]
           ,[delphotos]
           ,[growthtxselname]
           ,[delphotos2]
           ,[designno]
           ,[designreplaceno]
           ,[size]
           ,[dindantype]
           ,[contractno1]
           ,[contractno2]
           ,[cfno]
           ,[calldate]
           ,[from]
           ,[reason]
           ,[time7]
           ,[time8]
           ,[time9]
           ,[time10]
           ,[authorize]
           ,[discount2]
           ,[authorize2]
           ,[bz4]
           ,[satisfaction1]
           ,[satisfaction2]
           ,[satisfaction3]
           ,[satisfaction4]
           ,[satisfaction5]
           ,[satisfaction6]
           ,[satisfaction7]
           ,[bz5]
           ,[send4]
           ,[send5]
           ,[waiter9]
           ,[curno]
           ,[xplrr]
           ,[xplrtime]
           ,[satisfaction8]
           ,[VisitPeople1]
           ,[VisitPeople2]
           ,[VisitPeople3]
           ,[VisitPeople4]
           ,[VisitPeople5]
           ,[VisitPeople6]
           ,[VisitPeople7]
           ,[VisitPeople8]
           ,[VisitTime1]
           ,[VisitTime2]
           ,[VisitTime3]
           ,[VisitTime4]
           ,[VisitTime5]
           ,[VisitTime6]
           ,[VisitTime7]
           ,[VisitTime8] from dindan_cc where atid = @autoid

--删除临时表;
drop table dindan_cc
end