-- ת��ʷʱ���˵Ķ����ӱ������ݿ�������db���ݿ���;
-- ����12�ű�;
-- ���裺�½����ݿ�back,Ȼ��ӱ����ﻹԭ,�����������id='...'�������ڵĶ����ij�Ҫ���db��Ķ���,��ִ�С�

--1.dindansp��;
set IDENTITY_INSERT [db].[dbo].[dindansp] ON
insert into [db].[dbo].[dindansp]
			([id]
           ,[spid]
           ,[shuliang]
           ,[kind]
           ,[price]
           ,[name]
           ,[no]
           ,[status1]
           ,[status2]
           ,[status3]
           ,[status4]
		   ,[autoid]
           ,[date1]
           ,[date2]
           ,[date3]
           ,[date4]
           ,[name1]
           ,[name2]
           ,[name3]
           ,[name4]
           ,[hqdate]
           ,[hqtime]
           ,[urgent]
           ,[taketime]
           ,[no2]
           ,[status5]
           ,[status6]
           ,[date5]
           ,[date6]
           ,[name5]
           ,[name6]
           ,[growthtxname]
           ,[ps]
           ,[zs]
           ,[ren1]
           ,[ren2]
           ,[hqstatus]
           ,[bz]) select * from [back].[dbo].[dindansp] where id='111111'
SET IDENTITY_INSERT [db].[dbo].[dindansp] OFF

--2.dindanbukuan��;
set IDENTITY_INSERT [db].[dbo].[dindanbukuan] ON
insert into [db].[dbo].[dindanbukuan] ([autoid],[id],[money],[ren],[date],[bz],[kind],[ren2],[item],[paytype],[jdd],[financecheck]) select [autoid],[id],[money],[ren],[date],[bz],[kind],[ren2],[item],[paytype],[jdd],[financecheck] from [back].[dbo].[dindanbukuan] where id='111111'
SET IDENTITY_INSERT [db].[dbo].[dindanbukuan] OFF

--3.dindanbukuan2��;
set IDENTITY_INSERT [db].[dbo].[dindanbukuan2] ON
insert into [db].[dbo].[dindanbukuan2] ([autoid],[id],[money],[ren],[date],[bz],[kind],[ren2]) select [autoid],[id],[money],[ren],[date],[bz],[kind],[ren2] from [back].[dbo].[dindanbukuan2] where id='111111'
SET IDENTITY_INSERT [db].[dbo].[dindanbukuan2] OFF

--4.dindan��;
insert into [db].[dbo].[dindan] select * from [back].[dbo].[dindan] where id='111111'

--5.photoprint��;
insert into [db].[dbo].[photoprint] select * from [back].[dbo].[photoprint] where id='111111'

--6.client��;
insert into [db].[dbo].[client] select * from [back].[dbo].[client] where id='111111'

--7.burncdreg��;
insert into [db].[dbo].[burncdreg] select * from [back].[dbo].[burncdreg] where id='111111'

--8.digitalwork��;
insert into [db].[dbo].[digitalwork] select * from [back].[dbo].[digitalwork] where id='111111'

--9.mywork;
insert into [db].[dbo].[mywork] select * from [back].[dbo].[mywork] where id='111111'

--10.dindanjd��;
insert into [db].[dbo].[dindanjd] select * from [back].[dbo].[dindanjd] where id='111111'

--11.dindansp2��;
insert into [db].[dbo].[dindansp2] select * from [back].[dbo].[dindansp2] where id='111111'

--12.dindansp3��;
insert into [db].[dbo].[dindansp3] select * from [back].[dbo].[dindansp3] where id='111111'