将数据从一个数据库表传输到另一数据库表. [英] transfer data from one database table to another database table..

问题描述

大家好，

我在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

请参阅此链接:

http://www.w3schools.com/sql/sql_select_into.asp [

Refer this link:

http://www.w3schools.com/sql/sql_select_into.asp[^]

这篇关于将数据从一个数据库表传输到另一数据库表.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！