如何从一个数据库插入另一个数据库 [英] how to insert from one database to another database

问题描述

i必须将数据从一个数据库复制到另一个数据库

不在第一个数据库中

  INSERT   INTO 测试.dbo.Item_mt 选择 * 来自 Test1.dbo.Item_mt 
  where  Test.dbo.Item_mt.ItemCode<> Test1.dbo.Item_mt.ItemCode 

但我收到错误





请帮助



问候

Nirmala Saravanan

解决方案

尝试这样并在插入和选择列表中提供所有列名。两者应该相同。



< pre lang =sql> INSERT INTO [测试]。[dbo]。[Item_mt]
（[ItemCode]
，[Col1]
，[Col2]）
选择 A.ItemCode
， A.Col1
，A.Col2
FROM Test1.dbo.Item_mt A
left Outer 加入 [测试]。[dbo]。[Item_mt] B ON
B.ItemCode<> A.ItemCode

查看此示例..

http://stackoverflow.com/questions/15653732/insert-data-from-db-to-another-db [ ^ ]

http://www.mssqltips.com/ sqlservertutorial / 203 / simple-way-to-import-data-into-sql-server / [ ^ ]

http://www.c-sharpcorner.com/Blogs/15899/insert-values -from-one-database-table-to-another-database-ta.aspx [ ^ ]

hi,

i have to copy data from one database to another database
which is not in first database

INSERT INTO Test.dbo.Item_mt select *  from Test1.dbo.Item_mt
where Test.dbo.Item_mt.ItemCode <> Test1.dbo.Item_mt.ItemCode

but iam getting an error


Pls Help

Regards
Nirmala Saravanan

解决方案

Try like this and provide all your column names in insert and select list.Both should be same.

INSERT INTO [Test].[dbo].[Item_mt]
           ([ItemCode]
           ,[Col1]
           ,[Col2])
    select A.ItemCode 
           ,A.Col1
           ,A.Col2
 FROM   Test1.dbo.Item_mt A
left Outer Join [Test].[dbo].[Item_mt] B ON
B.ItemCode <> A.ItemCode

see this examples..
http://stackoverflow.com/questions/15653732/insert-data-from-db-to-another-db[^]
http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/[^]
http://www.c-sharpcorner.com/Blogs/15899/insert-values-from-one-database-table-to-another-database-ta.aspx[^]

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