清除数据库重复数据

select * into BudgetTemp from Tblesbudget where 1=2  --创建表结构

declare  my_cursor cursor for
select BudgetNO,DomainID from Tblesbudget group by BudgetNO,DomainID
open my_cursor

Declare @BudgetNO varchar(64)
Declare @DomainID varchar(64)

fetch next from my_cursor into @BudgetNO,@DomainID

while @@fetch_status = 0
begin
 insert into BudgetTemp
 select top 1 * from Tblesbudget where BudgetNO=@BudgetNO and DomainID=@DomainID
 fetch next from my_cursor into @BudgetNO,@DomainID
end

close my_cursor
deallocate my_cursor

delete  from Tblesbudget
insert into Tblesbudget select * from BudgetTemp
drop table BudgetTemp