Posted by Roy Harvey on 07/23/07 13:41

Outside of a trigger, no. But it is exactly the sort of thing that
triggers are for.

Roy Harvey
Beacon Falls, CT

On Mon, 23 Jul 2007 13:27:13 -0000, michael <mharen@gmail.com> wrote:

>I have a column Last_Updated (uniqueidentifier) on a table. I'd like
>this column to get a new guid (NEWID()) each time any column in the
>row is updated.
>
>Is there an automatic way to do this outside of triggers?
>
>Here's an example of what I'm looking for:
>
>CREATE TABLE GuidTest (ID INT PRIMARY KEY IDENTITY, Status INT,
>LastUpdated UNIQUEIDENTIFIER DEFAULT (NEWID()))
>INSERT INTO GuidTest (Status) VALUES (10)
>INSERT INTO GuidTest (Status) VALUES (20)
>INSERT INTO GuidTest (Status) VALUES (30)
>
>SELECT ID, Status, LastUpdated FROM GuidTest
>UPDATE GuidTest SET Status = 31 WHERE ID = 3
>SELECT ID, Status, LastUpdated FROM GuidTest
>-- Would like GUID on ID=3 to be different in second select
>
>DROP TABLE GuidTest
>
>Thanks,
>Michael

[Back to original message]