使用 SQL Server 2012 将记录从一个数据库插入到另一个数据库

Question

我正在尝试将记录从CustomerManagmentDB插入到我使用以下SQL执行命令创建的名为Practiceone的新数据库中，但未能这样做。

USE [Practiceone];
GO
INSERT [Suppliers]
(
    [SupplierID],
    [SupplierName],
    [ContactName],
    [Address],
    [City],
    [PostalCode],
    [Country],
    [Phone]
)
SELECT
        [SupplierID],
        [SupplierName],
        [ContactName],
        [Address],
        [City],
        [PostalCode],
        [Country],
        [Phone]
    FROM
        [CustomerManagementDB].[dbo].[Suppliers]
    WHERE
        [supplierID] = 22;

Answer 1

插入中的列名不应有引号

    insert into Suppliers (SupplierID,supplierName,ContactName,
 Address,City,PostalCode,Country,Phone)
 select SupplierID,SupplierName,ContactName,Address,City,PostalCode,Country,Phone
 from CustomerManagementDB.dbo.Suppliers
 where supplierID=22

Answer 2

从插入语句中删除单引号。例如：插入供应商(供应商 ID(...

您的查询应如下所示：

INSERT INTO Suppliers (SupplierID,supplierName,ContactName,Address,City,PostalCode,Country,Phone)
SELECT SupplierID,SupplierName,ContactName,Address,City,PostalCode,Country,Phone FROM CustomerManagementDB.dbo.Suppliers
WHERE SupplierID=22