Re: Find most recent rows, generically?

what exactly does 'identity' mean in sql server? if not the datatype, or a sequence or primary key, then what else? I'm struggling to understand what you are asking for here.

DL wrote:
>
> Thanks anyway, but you missed my question, I don't have problem
> getting data types for columns of a table, I was wondering if or what
> is the equivalent of "identity"(MS SQL Server) from Oracle.
>
> DL
>
> mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0202180431.1768bf6f_at_posting.google.com>...
> > donlcs_at_yahoo.com (DL) wrote in message news:<604bb90c.0202172222.a375f10_at_posting.google.com>...
> > > Thanks for the response, Jim, let me re-phrase my question, with MS
> > > SQL Server, when I add a column and define it as integer, identity,
> > > later I can find out if that column is of data type int etc., what's
> > > Oracle's equivalent of "Identity" if any? and if yes, which system
> > > table do I go to determine it? Thanks.
> > >
> > > DL
> > >
> > > "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<9qhb8.431$Ot2.153407_at_sccrnsc01>...
> > > > 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
> > The one way that I use to find out the datatype is to describe the table
> > and it will list all the variables and their datatypes
> > Michael Ngong( Sr DBA)
Received on Mon Feb 18 2002 - 22:44:36 CET