将数据从一个数据库表传输到另一数据库表.

本文介绍了将数据从一个数据库表传输到另一数据库表.的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好， 我在sql server上有问题. 我想将 DATABSE_1 的 TABLE_1 数据从传输到 TABLE_1 中的 DATABASE_2 .这是我在服务器上处理的.我必须在哪个查询中将传输数据从 DATABASE_1 写入到 DATABASE_2 ..? 帮帮我.. 谢谢 -JAGADiSH (欢呼声)

hi to all., i have a problem with sql server. I want to transfer TABLE_1 data of DATABSE_1 from to DATABASE_2 in TABLE_1. This is i am handling in a server. Which query i have to write transfer data from DATABASE_1 to DATABASE_2..? help me.. thanks - JAGADiSH (Cheers)

推荐答案

尝试一下， Hi try this, SET IDENTITY_INSERT DATABASE_2.dbo.TABLE_1 ON GO insert into DATABASE_2.dbo.TABLE_1 select * from DATABSE_1.dbo.TABLE_1 GO SET IDENTITY_INSERT DATABASE_2.dbo.TABLE_1 OFF GO

最好的问候 Ab Abulubbad

Best Regards Ab Abulubbad

SET IDENTITY_INSERT DB2.dbo.TABLE_1 ON INSERT INTO DB2.dbo.TABLE_1 SELECT * FROM DB1.dbo.TABLE_1 SET IDENTITY_INSERT DB2.dbo.TABLE_1 OFF GO

试试这个 Try this one SELECT * INTO DestinationDB..MyDestinationTable FROM SourceDB..MySourceTable

请参阅此链接: www.w3schools/sql/sql_select_into.asp [ ^ ]

Refer this link: www.w3schools/sql/sql_select_into.asp[^]