Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Unanswered: Triigers in SQL Server

    Hello,

    I am new to SQL Server world. So please help me out.

    I have a table with employee details and total salary (Table : Emp_Det).
    Also there is another table called Salary split (Table: Sal_Det). I have created a trigger on the first table (Emp_Det) Which takes the total salary from the table and updates/inserts the Sal_Details table.
    Now when I do a bulk insert from using (insert into select statement) I get the salary details of only the last employee in the other table.

    Is that the trigger is fired after all the inserts or is it done at row level.

    Thanks in advance.

    Regards,
    Ramesh

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    The following link will help you:

    link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •