【速达软件】【速达3000】新账套导入旧账套资料SQL

（建账初始化）新建帐套复制资料语句

旧账套：SD11800N_001复件

新账套：SD11800N_A1

--地区资料
select * from AREA       
insert into SD11800N_A1.dbo.AREA
select * from SD11800N_001复件.dbo.AREA

--部门资料
select * from DEPARTMENT 
insert into SD11800N_A1.dbo.DEPARTMENT
select * from SD11800N_001复件.dbo.DEPARTMENT

--员工资料
select * from dbo.employ
select * from dbo.emptype
select * from dbo.emptypelab

insert into SD11800N_A1.dbo.emptypelab
select * from SD11800N_001复件.dbo.emptypelab

insert into SD11800N_A1.dbo.emptype
select * from SD11800N_001复件.dbo.emptype

insert into SD11800N_A1.dbo.employ
select * from SD11800N_001复件.dbo.employ

--客户/供应商资料
update SD11800N_001复件.dbo.CLIENT set opid=1 where opid<>1

insert into SD11800N_A1.dbo.CLIENT
select * from SD11800N_001复件.dbo.CLIENT  where opid<>1

update SD11800N_A1.dbo.CLIENT set balance=0&nbs