如何在SQL Server 2008中编写INSERT触发器以确保员工数据完整性？

CREATE TRIGGER trig_Update_Employee
ON [EmployeeResult]
FOR INSERT
AS
BEGIN
  -- Retrieve the inserted row data
  SELECT *
  INTO #InsertedRows
  FROM INSERTED;

  -- Check if the inserted employee exists in the Employee table
  SELECT COUNT(*)
  INTO #EmployeeCount
  FROM Employee
  WHERE Name IN (SELECT Name FROM #InsertedRows)
    AND Department IN (SELECT Department FROM #InsertedRows);

  -- Insert missing employee records
  IF #EmployeeCount < 1
  BEGIN
    -- Dynamically generate the INSERT statement based on the inserted rows
    DECLARE @InsertStatement NVARCHAR(MAX) = 'INSERT INTO Employee (Name, Department) VALUES ';
    SELECT @InsertStatement += '("" + Name + "", ""' + Department + '"")'
    FROM #InsertedRows;

    -- Execute the dynamic INSERT statement
    EXEC sp_executesql @InsertStatement;
  END;
END;