首先您在目标库里面把表建好.我演示怎么把源库stock中的一个表userinfo的uname和psw字段的所有记录如何拷贝到目标库storemanagement 的一个表userinfo1中的 uname 和psw去.您可以根据需要适当改一下.我已经调试过了,没有问题.一下语句在查询分析器里面能够执行. use stock //stock 是源库 go declare @@uname char(10),@@psw char(10),@@countno integer,@@i integer select @@countno=count(*) from userinfo //userinfo 是源表 declare mycursor cursor for select uname,upsw from userinfo open mycursor fetch mycursor into @@uname ,@@psw set @@i=1 while @@i<=@@countno begin use storemanagement //storemanagement 是目标库
insert into userinfo1 values(@@uname,@@psw) //userinfo 是目标表 use stock
set @@i=@@i+1 fetch next from mycursor into @@uname ,@@psw end close mycursor DEALLOCATE mycursor
use stock //stock 是源库
go
declare @@uname char(10),@@psw char(10),@@countno integer,@@i integer
select @@countno=count(*) from userinfo //userinfo 是源表
declare mycursor cursor for select uname,upsw from userinfo
open mycursor
fetch mycursor into @@uname ,@@psw
set @@i=1
while @@i<=@@countno
begin
use storemanagement //storemanagement 是目标库
insert into userinfo1 values(@@uname,@@psw) //userinfo 是目标表
use stock
set @@i=@@i+1
fetch next from mycursor into @@uname ,@@psw
end
close mycursor
DEALLOCATE mycursor