lyfz_repos/经典版源码/document/数据库维护脚本/清除多余条目命令.txt

select distinct * into #temp from dindan
go
delete dindan
go
insert dindan select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from dindansp
go
delete dindansp
go
insert dindansp select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from photoprint
go
delete photoprint
go
insert photoprint select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from dindanbukuan
go
delete dindanbukuan
go
insert dindanbukuan select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from dindanbukuan2
go
delete dindanbukuan2
go
insert dindanbukuan2 select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from client
go
delete client
go
insert client select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from burncdreg
go
delete burncdreg
go
insert burncdreg select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from digitalwork
go
delete digitalwork
go
insert digitalwork select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from mywork
go
delete mywork
go
insert mywork select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from dindanjd
go
delete dindanjd
go
insert dindanjd select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from dindansp2
go
delete dindansp2
go
insert dindansp2 select * from #temp Sqlclub  
go
drop table #temp
go
select distinct * into #temp from dindansp3
go
delete dindansp3
go
insert dindansp3 select * from #temp Sqlclub  
go
drop table #temp
go