sql根据条件跨库导数据

直接上问题：比如我有数据库A和数据库B 我想把A中的表user（username,useraddress） 根据条件查询出来的数据 导入数据库B中的表user（username,useraddress）（两个表的字段数不完全相同） 如果用存储过程能做么 请给个实例 或者ASP做也行 也要实例 谢谢

我用的是sqlserver2005 存储过程我写好了 但是执行的时候会提示 select * from A.user where uer=11 对象名A.user无效

是不是库B没有库A的权限啊 怎么设置的 帮我弄好了加分啊~~谢谢

楼主描述的是etl过程的一部分，可以使用etl工具，也可以使用sql。
sql：首先b库用户需要有a库user表达权限
insert into B.user(username,useraddress)
select A.user.USERNAME,A.user.USERADDRESS FROM A.user

在B库中建个存储过程，主要代码如下： for tr in (select from a.user where 条件) loop insert into user values(tr.username,tr.useraddress); end loop; 记得把A中user的select权限分给B库

update b set b.com_introduce = a.company_intro --这里改改 from australia.dbo.companytest as a, yimingong.dbo.company as b where (a.id = 2 and b.com_id = 1) or (a.id = 14 and b.com_id = 2) or (a.id = 18 and b.com_id = 3) or (a.id = 5 and b.com_id = 4) or (a.id = 16 and b.com_id = 5) or (a.id = 18 and b.com_id = 6) or (a.id = 15 and b.com_id = 7) or (a.id = 4 and b.com_id = 8) or (a.id = 3 and b.com_id = 9) or (a.id = 12 and b.com_id = 10) or (a.id = 6 and b.com_id = 11) or (a.id = 8 and b.com_id = 12) or (a.id = 11 and b.com_id = 13) or (a.id = 10 and b.com_id = 14) or (a.id = 9 and b.com_id = 15) or (a.id = 7 and b.com_id = 16) or (a.id = 19 and b.com_id = 17) or (a.id = 20 and b.com_id = 19) or (a.id = 21 and b.com_id = 20) or (a.id = 22 and b.com_id = 21)

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息