Question

采用微软服务器管理演播室2008年。我做了简单的交易:

BEGIN TRAN

SELECT ko.ID, os.ID AS ID2
FROM table_a AS ko
JOIN table_b AS os ON os.ID=ko.ID
WHERE (ko.the_date IS NOT NULL AND os.the_date IS NULL);

UPDATE table_b SET the_date=ko.the_date
FROM table_a AS ko
JOIN table_b AS os ON os.ID=ko.ID
WHERE (ko.the_date IS NOT NULL AND os.the_date IS NULL);

SELECT ko.ID, os.ID AS ID2
FROM table_a AS ko
JOIN table_b AS os ON os.ID=ko.ID
WHERE (ko.the_date IS NOT NULL AND os.the_date IS NULL);


ROLLBACK

因此,选举和选举事务管理局应当相同。结果应该回到零头。但是,全国人民民主党影响到一行,少于从非行获得的选任考试。

(61英亩)

(60英亩)

(0 受影响)

我在这里失踪了吗?

Answer 1

我怀疑最可能的原因是,你的例子中的表_a有一行重复的身份证——这种情况是,在你的第一部<代码>上加入的新增一行,但<代码>update仅涉及表_b中的行文,因此,重复行不成。本声明应赋予你以下权力:

SELECT ko.ID
FROM table_a AS ko
JOIN table_b AS os ON os.ID=ko.ID
WHERE (ko.the_date IS NOT NULL AND os.the_date IS NULL)
GROUP BY ko.ID
HAVING COUNT(*) > 1

Answer 2

附录从中发现的模糊不清,例如:

CREATE TABLE dbo.source
    (
      id INT NOT NULL ,
      SomeNumber INT
    )
GO
CREATE TABLE dbo.target
    (
      id INT NOT NULL
             PRIMARY KEY ,
      SomeNumber INT
    )
GO
INSERT  INTO dbo.source
        ( id, SomeNumber )
        SELECT  1 ,
                2
        UNION ALL
        SELECT  1 ,
                3

INSERT  INTO dbo.target
        ( id, SomeNumber )
        SELECT  1 ,
                0

UPDATE  dbo.TARGET
SET     SomeNumber = s.SomeNumber
FROM    dbo.source AS s
        JOIN dbo.TARGET AS t ON s.id = t.id

你们的目标表中的一行在源头上有两个对应点,我们不能事先知道最终将更新目标的价值。

友情链接