Re: Find most recent rows, generically?

You can't. If it is important to know if it was recent then you need a column to model that attribute.
Jim
"DL" <donlcs_at_yahoo.com> wrote in message news:604bb90c.0202150930.49ef0fc5_at_posting.google.com...
> Hi,
>
> First of all, I thank those who have been very helpful in the past.
> How to find most recent rows, say, 10, (for insert and update
> transactions), generically?
>
> For insert:
> Well, one can find PK column of a given table, suppose, single column,
> then determine data type of that column, if it is of integer or
> similar type data,
> 1(a) how would one know that it uses "identity" attribute for it
> (thus, incremental)?
> 1(b) and if it does not, how to proceed?
> 2, what if it is of random alphnumeric?
> 3, what if it is of composite keys?
>
> For update:
> ???
>
> * Question category 1 is most important to me for now.
>
> Thanks.
>
> DL
Received on Sat Feb 16 2002 - 01:08:39 CET