Re: snapshot vs trigger

Hi,

JS>From: jes_at_usa.pipeline.com(Johnnie Suggs) JS>Subject: snapshot vs trigger

JS>i have a user who wants to update a seconday table when 
JS>a row is updated in a particular table.  he knows he can 
JS>write a trigger..but...i was wondering if a snapshot wouldn't 
JS>be better? 

If the two tables are within the same database, a trigger is better because it guarantee the consistence between the two tables. However, if they are in two different databases, a snapshot will be better.

William.
william.lee_at_cwolhk.com
___
* UniQWK #5138* Have you ever listen to Yukie Nishimura's music? Received on Tue Oct 10 1995 - 00:00:00 CET