Re: incrementing updates and locks

On 9/16/10 3:54 PM, Aras Angelo wrote:
> Hello All
>
> I have a column in my table which is incrementally updated.

Try to give us more details...

Does the column need have contiguous values or are "gaps" ok?  That is, does it have to be 1,2,3,4,...,N-1,N or is it
okto have something like 1,3,4,7,...,M (where M>N) for N rows? 

Is the value updated every time the row is changed, or is it set once only?

If gaps are OK, then a sequence is a simple answer.

Craig