sql触发器无法按预期工作

Question

当一行被添加到客户表时，它应该:

复制到另一个名为 new_customer 的表

删除客户表中的行。

在客户表中只有一个字段是电话号码。

该字段应复制到新的客户表中，并应从客户表中删除。

请谁能告诉我这个触发器有什么问题.....

CREATE TRIGGER update_cus
ON customer
FOR update AS
   IF (COLUMNS_UPDATED() & 1) > 0
      BEGIN

      INSERT INTO new_customer
         (Phone number
            )
         SELECT 'NEW',
            ins.Phone number
         FROM inserted ins

         SELECT 'OLD', 
            del.Phone number
         FROM deleted del

   END

Answer 1

我猜

CREATE TRIGGER update_cus
ON customer
FOR update AS
   IF EXISTS (SELECT * FROM INSERTED)
   BEGIN

      INSERT INTO new_customer ([Phone number])
         SELECT 'NEW', ins.[Phone number]
         FROM inserted ins

      DELETE customer WHERE
         [Phone number] IN (SELECT [Phone number] FROM deleted)

   END