Hi - can anybody help me with this query.
In an update trigger, how do you know which record in the Inserted table refers to which record in the Deleted table in the case of an update statement updating multiple records.
My guess is that the two tables are in the same sequence. The only way that I can come up with is to SELECT the pseudo tables into temp tables with an identity column.
Is this the only way?
Thanks
Mark
In an update trigger, how do you know which record in the Inserted table refers to which record in the Deleted table in the case of an update statement updating multiple records.
My guess is that the two tables are in the same sequence. The only way that I can come up with is to SELECT the pseudo tables into temp tables with an identity column.
Is this the only way?
Thanks
Mark