你即將離開本站

並前往https://learn.microsoft.com/en-us/answers/questions/85837/how-to-create-a-trigger-for-a-table-whose-values-d.html

how to create a trigger for a table whose values depends on join

CREATE TRIGGER BuyDate ON UserPackages after insert as update u set BuyDate=GETDATE() FROM inserted i INNER JOIN UserPackages p on i.ID = p.

確定！ 回上一頁

查詢 「Oracle update inner」的人也找了：

  1. Oracle update join
    2.
  2. Oracle update multiple columns
    3.
  3. Oracle update INNER JOIN multiple columns
    4.
  4. Oracle UPDATE EXISTS
    5.
  5. Oracle Update from another table
    6.
  6. Oracle update multiple tables
    7.
  7. Oracle UPDATE from SELECT same table
    8.
  8. Oracle with update
    9.