从一个表插入到另一个表（不同的数据库）

Da black ninja 发表于 Dev

大黑忍者

Auth2.dbo.Accounts： account_id，login_name，password和其他列...

Auth.dbo.Account： account_id，account，password，其他列...

我想从“ Auth.dbo.Account ”到“ Auth2.dbo.Accounts ”（account_id，login_name，密码）插入帐户（account_id，account，password），并提供其他所需的列值。

我希望这能行得通，但是一旦我在SQL Management Studio中写了代码，我在“从Auth.dbo.account中选择account_id”附近收到了一个错误语法错误。

INSERT [dbo].[Accounts] ([account_id], [login_name], [password],
       [referral_id], [referral_code], [pcbang], [block],
       [withdraw_remain_time], [age], [auth_ok],
       [last_login_server_idx], [event_code], [server_list_mask], 
       [result], [ip], [game_code], [gamecode], [login_event],
       [email], [security_a_1], [security_a_2], [security_a_3],
       [security_a_4], [security_q_1], [security_q_2], [security_q_3],
       [security_q_4], [votepoints], [cash], [country]) 
VALUES (select account_id from auth.dbo.Account, N'Imad', 
               N'3cfbbd2ae3c3e416c6d00a5a12ee60e8', NULL, NULL, 
               0, 0, NULL, -1997, 1, NULL, NULL, NULL, NULL, 
               N'::1', NULL, NULL, NULL, N'[email protected]',
               NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 
               0, 189, NULL)

韦尔切利

尝试简单INSERT/SELECT。在这种情况下account_id将来自，auth.dbo.Account并且所有其他值将是常量。

INSERT Auth2.[dbo].[Accounts] ([account_id], [login_name], [password], [referral_id], [referral_code], [pcbang], [block], [withdraw_remain_time], [age], [auth_ok], [last_login_server_idx], [event_code], [server_list_mask], [result], [ip], [game_code], [gamecode], [login_event], [email], [security_a_1], [security_a_2], [security_a_3], [security_a_4], [security_q_1], [security_q_2], [security_q_3], [security_q_4], [votepoints], [cash], [country]) 
select account_id , N'Imad', N'3cfbbd2ae3c3e416c6d00a5a12ee60e8', NULL, NULL, 0, 0, NULL, -1997, 1, NULL, NULL, NULL, NULL, N'::1', NULL, NULL, NULL, N'[email protected]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 189, NULL from auth.dbo.Account;

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。