Home Forums SQL Server 2008 SQL Server Newbies Creating Trigger To Update Total On 'Parent' Table RE: Creating Trigger To Update Total On 'Parent' Table

  • September 20, 2012 at 7:03 am

    #1540050

    I'm Firebird user, in Firebird context value (inserted, updated, or deleted) in trigger is always single row which not always true in Sql Server.

    To make it clearer for you, SQL Server uses two virtual tables in a trigger Inserted and Deleted. Both have all the values for the rows affected during the event that activated the trigger.

    You shoulduse this tables (Inserted in this case) to create your trigger and make it work for multiple rows.

    What you're asking is easy if you understand this, that's why I prefer to explain it rather than giving you some code.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2