Modifying Primary Key Values

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: ggeshev (ggeshev_at_tonegan.bg)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 10:30:25 +0300

Hello!

Let's suppose I have a table MyTable (A INT PRIMARY KEY, B VARCHAR(20)).

I send an UPDATE script to sql server.

In this script I modify the A column /the primary key/.

In an AFTER UPDATE TRIGGER I would like by analyzing "inserted" and
 "deleted" virtual tables to understand which row from "inserted"
corresponds to which row in "deleted".

You understand that I cannot rely for that purpose on the A column /the
primary key/ because values in it are changed.

How can I make the true correspondence between "new" and "old" rows?

Thank you!

Relevant Pages

  • Re: An AWK question
    ... > I have a script that tells me when a mailbox exceeds 2MB. ... > another purpose. ... how can I modify this script to tell me when a file is ...
    (freebsd-questions)
  • An AWK question
    ... I have a script that tells me when a mailbox exceeds 2MB. ... another purpose. ... how can I modify this script to tell me when a file is ...
    (freebsd-questions)
  • Re: Modifying a record field value while not blocking it to others
    ... And of course again the record you are trying to modify has not to be 'open' ... someone opens that ID=12 record everything in it is locked. ... often add a script line which opens a random record if the file holds enough ... system where customers use Credits when renting items and get Credits ...
    (comp.databases.filemaker)
  • Re: modifying objects in ADAM ADSIEDIT
    ... which is the NetBIOS name I referred to. ... ' Prompt for NetBIOS name of object in AD. ... ' Prompt for the attribute to modify. ... How do I script this by just modifying ...
    (microsoft.public.windows.server.scripting)
  • Re: sus office updates
    ... You can modify the registry ... or you can script a change for MSI to add ... my "encrypted" product code for Office 2003 Professional is: ...
    (microsoft.public.sms.tools)