如果我在数据库bbs中有一个login表,在数据库test中,有一个bbs_user表,我想把bbs_user表中的user_name字段复制到login表中的name字段,该怎么写,我是这样写的,可是不行?!!!INSERT INTO login.name SELECT user_name FROM test bbs_user
insert into login(name) select user_name from test.dbo.bbs_user
use bbs insert into login(name) select user_name from test.dbo.bbs_user
SELECT user_name
FROM test bbs_user
insert into login(name) select user_name from test.dbo.bbs_user