所有状态值相同，然后更新另一个表状态。

Question

我有两张桌子，它们的价值是

lot-master

event-id   lotid    status
1           1        Awarded
1           2        Awarded
1           3        Awarded

和event-master

event-id     status
1             Open

如果授予所有lot-master状态，则使用event-master查询更新event-master状态。

Answer 1

不过，如果你想这样做，那么你可以这样做，

DECLARE @Count              AS INT = 0,
        @ConditionCount     INT = 0

SELECT @Count = COUNT(1) FROM   lot-MASTER

SELECT @ConditionCount = COUNT(1) FROM  lot-MASTER WHERE  STATUS = 'Awarded'

IF (@ConditionCount = @Count)
BEGIN
    UPDATE EVENT-MASTER
    SET    STATUS = 'Awarded'
END