insert into worklog(emp_id) select max(empid)+1 from worklog insert into wl_items(wl_id,type) select id=(select max(wl_id)+1 from worklog),type from A_simu
打开备份库 执行 EXPORT TO ./data/表名.IXF OF IXF MESSAGES ./exportmsgs.txt SELECT * FROM 表名打开正式库 执行 delete from 表名; IMPORT FROM ./data/表名.IXF OF IXF MESSAGES ./exportmsgs.txt INSERT INTO 表名;
保持主从关系对应呀!比如 在A_simu 的 worklog主表 wl_id emp_id 3 2 work_items从表 item_id wl_id type 12 3 a 16 3 b 导到A_real中 可能就成了 worklog主表 wl_id 41 work_items从表 item_id wl_id type 56 41 a 57 41 b
有个高手给我写 ,没有成功!大家帮忙看看!? declare @wl_id int declare @emp_id int declare @id intDECLARE worklog_cursor CURSOR FOR SELECT * FROM worklog --这里可以加查询条件open worklog_cursorFETCH NEXT FROM worklog_cursor into @wl_id,@emp_id-- Check @@FETCH_STATUS to see if there are any more rows to fetch. WHILE @@FETCH_STATUS = 0 BEGIN -- This is executed as long as the previous fetch succeeds. insert into [目标数据库名].dbo.worklog(emp_id) values(@emp_id) select @id=SCOPE_IDENTITY() insert into [目标数据库名].dbo.wl_items(wl_id,type) select @id as wl_id,type from wl_items b where b.wl_id=@wl_id FETCH NEXT FROM worklog_cursor into @wl_id,@emp_id ENDCLOSE worklog_cursor DEALLOCATE worklog_cursor GO
先谢过,我小弟了! 我用的系统是WIN 2000 SERVER 数据库SQL Server 2000 大家,积极回答呀!分不够我可以再加的! 如果有什么更好的解决方案,也可指点思路! 救命了,很着急用的!
把数据导到A_real中!
insert into wl_items(wl_id,type) select id=(select max(wl_id)+1 from worklog),type from A_simu
上面只列出A_simu中需要倒入A_real中的数据!
这只是表中的一部分!我只要导入显示的数据!
然后再在另外的数据库执行
EXPORT TO ./data/表名.IXF OF IXF MESSAGES ./exportmsgs.txt SELECT * FROM 表名打开正式库 执行
delete from 表名;
IMPORT FROM ./data/表名.IXF OF IXF MESSAGES ./exportmsgs.txt INSERT INTO 表名;
在A_simu 的 worklog主表 wl_id emp_id
3 2
work_items从表 item_id wl_id type
12 3 a
16 3 b
导到A_real中 可能就成了
worklog主表 wl_id
41
work_items从表 item_id wl_id type
56 41 a
57 41 b
declare @wl_id int
declare @emp_id int
declare @id intDECLARE worklog_cursor CURSOR FOR
SELECT * FROM worklog
--这里可以加查询条件open worklog_cursorFETCH NEXT FROM worklog_cursor
into @wl_id,@emp_id-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This is executed as long as the previous fetch succeeds.
insert into [目标数据库名].dbo.worklog(emp_id) values(@emp_id) select @id=SCOPE_IDENTITY()
insert into [目标数据库名].dbo.wl_items(wl_id,type) select @id as wl_id,type from wl_items b where b.wl_id=@wl_id FETCH NEXT FROM worklog_cursor into @wl_id,@emp_id
ENDCLOSE worklog_cursor
DEALLOCATE worklog_cursor
GO
我用的系统是WIN 2000 SERVER
数据库SQL Server 2000
大家,积极回答呀!分不够我可以再加的!
如果有什么更好的解决方案,也可指点思路! 救命了,很着急用的!
我觉得这个问题,只用sql语句,就能解决的。????????????????????