SQL Update identifier

[ASB]

I need to include a record version number in an SQL server express (2008) database. Currently this is done manually, but it seems I ought to be able to do something like this automatically. All it is is a field that should change whenever an update is done.

Have tried a variety of searches to no great avail, any suggestions ?

Cheers.

[AtW]

Try using trigger on update: http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx

This can be performance bottleneck if you update a lot.

[ASB]

Try using trigger on update: http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx

This can be performance bottleneck if you update a lot.

AtW,

That is in fact what I am doing, but it just "feels" as though there ought to be a more automatic way. ISTR this was possible with oracle.

[DimPrawn]

You just create a column of type rowversion

http://msdn.microsoft.com/en-us/library/ms182776.aspx

Its value changes everytime the row is updated.

[ASB]

You just create a column of type rowversion

http://msdn.microsoft.com/en-us/library/ms182776.aspx

Its value changes everytime the row is updated.

Great, thanks !!

[AtW]

You just create a column of type rowversion

http://msdn.microsoft.com/en-us/library/ms182776.aspx

Its value changes everytime the row is updated.

That's a better technical advice than mine Dimmy... the first one I heard from you!

P.S. In my defence I felt really to suggest using Trigger in database...