Posted by michael on 07/23/07 13:27

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]