Re: Update Guid column on any update to table row
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 23 Jul 2007 22:08:15 +0000 (UTC)
michael (mharen@xxxxxxxxx) writes:
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?
I don't know what the purpose with this guid is, but there is a special
data type in SQL Server, timestamp, for this purpose. A timestamp is a
binary(8) values with no relation to date and time. Such a column is
automatically updated each time a row is touched. Furthermore, the
value is database-unique and monotonically growing.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Update Guid column on any update to table row
- From: michael
- Update Guid column on any update to table row
- Prev by Date: Re: How to Test Database Connectivity From a Workstation?
- Next by Date: Re: Ongoing purging of active records causes deadlocks
- Previous by thread: Re: Update Guid column on any update to table row
- Next by thread: Same field different values
- Index(es):
Relevant Pages
|
