Re: column ID problem
From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 07/06/04
- Next message: Jacky Luk: "Send a db replica to home"
- Previous message: Uri Dimant: "Re: column ID problem"
- In reply to: RioDD: "column ID problem"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 6 Jul 2004 10:50:36 +0100
No. There is no system function to return the IDENTITY value of an updated
row.
This shouldn't be a problem. If your UPDATE statement has a WHERE clause
then that WHERE clause specifies which rows were updated and you can use
that to retrieve the IDENTITY column for the updated rows. If you are
writing a trigger, use the INSERTED virtual table to retrieve data for the
updated rows.
-- David Portas SQL Server MVP --
- Next message: Jacky Luk: "Send a db replica to home"
- Previous message: Uri Dimant: "Re: column ID problem"
- In reply to: RioDD: "column ID problem"
- Messages sorted by: [ date ] [ thread ]
