Run new Trigger on old records

[jojo79]

I just created a new trigger for a table, Is their a way to run the trigger on all of the previous records in the table? or should I be doing something else. the trigger is an insert trigger. It basically moves information to another table.

 

[SQLDenis]

>>Is their a way to run the trigger on all of the previous records in the table

no, unless it is an update trigger and you do something like this
update table set id =id (basically update the whole table to the same value)

a trigger is event driven once something changes to the table (insert,delete,update) the trigger will fire

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[SQLSister]

I would definetly not want to affect all the records inthe table in a trigger. If you write it that way, then it willhappen every tim ea record is inserted.

Put the update code into a SQL statement and run from query analyzer to update the existing records.

Questions about posting. See faq183-874