而不是触发器来更新具有多个表的视图

我试图找到一个示例，说明如何使用替代触发器更新多个表上的视图。

也就是说，我想要更新该视图从中选择的多个表。

我找不到任何例子。如果有人能告诉我如何做到这一点那就太好了。

假设您在这里使用的是 SQLServer过于简单化 example

CREATE TABLE persons
(personid  int, 
 firstname varchar(32), 
 lastname  varchar(32));

CREATE TABLE employees
(employeeid int, 
 personid   int, 
 title      varchar(32));

CREATE VIEW vwEmployees AS
SELECT p.personid, employeeid, firstname, lastname, title
  FROM employees e JOIN persons p
    ON e.personid = p.personid;

CREATE TRIGGER tgEmployeesInsert ON vwEmployees
INSTEAD OF INSERT AS
BEGIN
  INSERT INTO persons (personid, firstname, lastname)
  SELECT personid, firstname, lastname
    FROM INSERTED

  INSERT INTO employees (employeeid, personid, title)
  SELECT employeeid, personid, title
    FROM INSERTED
END;

INSERT INTO vwEmployees (personid, employeeid, firstname, lastname, title)
VALUES(1, 1, 'Jhon', 'Doe', 'SQL Developer');

Note:事实上，你肯定要处理IDENTITY列以及 SQL Server 中的触发器是语句范围而不是行范围这一事实。

Here is SQLFiddle demo