--0.���ݵ�ǰdb��client����client_back��;
select [id]
      ,[name1]
      ,[name2]
      ,[phone1]
      ,[phone2]
      ,[qq1]
      ,[qq2]
      ,[addr1]
      ,[addr2]
      ,[occupation1]
      ,[occupation2]
      ,[birthday1]
      ,[birthday2]
      ,[time3]
      ,[area]
      ,[area2]
      ,[check1]
      ,[check2]
      ,[check3]
      ,[sex]
      ,[zodiac]
      ,[photo] into [db].[dbo].[client_back] from [db].[dbo].[client]
go

--1.��db��client��ȫ����¼���뵽#tempall����;
select [id]
      ,[name1]
      ,[name2]
      ,[phone1]
      ,[phone2]
      ,[qq1]
      ,[qq2]
      ,[addr1]
      ,[addr2]
      ,[occupation1]
      ,[occupation2]
      ,[birthday1]
      ,[birthday2]
      ,[time3]
      ,[area]
      ,[area2]
      ,[check1]
      ,[check2]
      ,[check3]
      ,[sex]
      ,[zodiac]
      ,[photo] into #tempall from [db].[dbo].[client]
go

insert into #tempall select [id]
      ,[name1]
      ,[name2]
      ,[phone1]
      ,[phone2]
      ,[qq1]
      ,[qq2]
      ,[addr1]
      ,[addr2]
      ,[occupation1]
      ,[occupation2]
      ,[birthday1]
      ,[birthday2]
      ,[time3]
      ,[area]
      ,[area2]
      ,[check1]
      ,[check2]
      ,[check3]
      ,[sex]
      ,[zodiac]
      ,[photo] from [2014].[dbo].[client]
go

--2.���˵���ȫ�ظ��ļ�¼;
--select distinct * into #tempdis from #tempall
--go
--drop table #tempall
--go
--�˲�ʡ�ԡ���

--3.��ȡָ���ֶεIJ��ظ���¼,���˵�����ȫ�ظ��ļ�¼;
select identity(int,1,1) as autoid, * into #temp1 from #tempall
go

select min(autoid) as autoid into #temp2 from #temp1 group by id
go

select [id]
      ,[name1]
      ,[name2]
      ,[phone1]
      ,[phone2]
      ,[qq1]
      ,[qq2]
      ,[addr1]
      ,[addr2]
      ,[occupation1]
      ,[occupation2]
      ,[birthday1]
      ,[birthday2]
      ,[time3]
      ,[area]
      ,[area2]
      ,[check1]
      ,[check2]
      ,[check3]
      ,[sex]
      ,[zodiac]
      ,[photo]
into [db].[dbo].[client#] from #temp1 where autoid in(select autoid from #temp2) order by id
go

--4.�����˺õļ�¼���²���ԭ��;
drop table #tempall
drop table #temp1
drop table #temp2
truncate table [db].[dbo].[client]
go

insert into [db].[dbo].[client]([id]
      ,[name1]
      ,[name2]
      ,[phone1]
      ,[phone2]
      ,[qq1]
      ,[qq2]
      ,[addr1]
      ,[addr2]
      ,[occupation1]
      ,[occupation2]
      ,[birthday1]
      ,[birthday2]
      ,[time3]
      ,[area]
      ,[area2]
      ,[check1]
      ,[check2]
      ,[check3]
      ,[sex]
      ,[zodiac]
      ,[photo]) 
select [id]
      ,[name1]
      ,[name2]
      ,[phone1]
      ,[phone2]
      ,[qq1]
      ,[qq2]
      ,[addr1]
      ,[addr2]
      ,[occupation1]
      ,[occupation2]
      ,[birthday1]
      ,[birthday2]
      ,[time3]
      ,[area]
      ,[area2]
      ,[check1]
      ,[check2]
      ,[check3]
      ,[sex]
      ,[zodiac]
      ,[photo] from [db].[dbo].[client#]
go

drop table [db].[dbo].[client#]
go
--5.����;