SQL Server 2008 – Help writing simple INSERT Trigger

by

You want to take advantage of the inserted logical table that is available in the context of a trigger. It matches the schema for the table that is being inserted to and includes the row(s) that will be inserted (in an update trigger you have access to the inserted and deleted logical tables which represent the the new and original data respectively.)

So to insert Employee / Department pairs that do not currently exist you might try something like the following.

CREATE TRIGGER trig_Update_Employee
ON [EmployeeResult]
FOR INSERT
AS
Begin
    Insert into Employee (Name, Department) 
    Select Distinct i.Name, i.Department 
    from Inserted i
    Left Join Employee e
    on i.Name = e.Name and i.Department = e.Department
    where e.Name is null
End

More Related Contents:

  1. Create Trigger to log SQL that affected table?
  2. SQL Server: Cannot insert an explicit value into a timestamp column
  3. How do I prevent a database trigger from recursing?
  4. I dont know sql syntax for my table [closed]
  5. Unable to Subtract Dates SQL Server
  6. Insert local .csv data in remote SQL Server via already working connection string
  7. Syntax combine two stored procedure into one [closed]
  8. How to delete duplicate rows in SQL Server?
  9. CROSS JOIN vs INNER JOIN in SQL
  10. How to cast the DateTime to Time
  11. How can I schedule a job to run a SQL query daily?
  12. Reset identity seed after deleting records in SQL Server
  13. How to avoid the “divide by zero” error in SQL?
  14. Multiple INSERT statements vs. single INSERT with multiple VALUES
  15. Real life example, when to use OUTER / CROSS APPLY in SQL
  16. Common Table Expression, why semicolon?
  17. T-SQL split string based on delimiter
  18. SQL Server 2008: how do I grant privileges to a username?
  19. How do I find duplicates across multiple columns?
  20. Can you access the auto increment value in MySQL within one statement?
  21. Generate script in SQL Server Management Studio
  22. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  23. How can I alter this computed column in SQL Server 2008?
  24. How to get the size of a varchar[n] field in one SQL statement?
  25. Stored procedure that exports data into csv files only exports to one file
  26. SQL Server: should I use information_schema tables over sys tables?
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. SQL take just the numeric values from a varchar
  29. How to execute a stored procedure inside a select query
  30. How to bulk insert only new rows in PostreSQL

Leave a Comment