Home Forums SQL Server 2008 SQL Server 2008 - General Trigger to update existing records RE: Trigger to update existing records

  • December 19, 2012 at 7:38 am

    #1570083

    Minnu (12/19/2012)

    Yes,

    i want to update pre-existing data,

    at present trigger is firing for only newly updated or inserted records.

    i want Trigger should be fired one time for pre-existing data....

    Please help

    well, here's the basic framework:

    1. read the trigger code.

    2. copy and paste it as an UPDATE statement

    3., Modify/change the where statement to affect only records that are not yet affected.

    again, without details, we can only offer vague suggestions.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!