Re: Equivalent to rowid in Oracle...

From: Greg Linwood (g_linwoodQhotmail.com)
Date: 03/21/04 

Date: Mon, 22 Mar 2004 10:33:08 +1100

RowId isnt just for physical rows - can also be used in a select statement
which is arguably its most common use in plsql. In tsql, you've got to
either use temp tables with identity or inefficient sql to achieve the same
thing. It's certainly something I wish tsql had..

Regards,
Greg Linwood
SQL Server MVP

"Tenaya" <ct@ct.ct> wrote in message
news:uiaqg52DEHA.3064@tk2msftngp13.phx.gbl...
> Greg,
>
> I believe there is a significant difference between the SQL Server
Timestamp
> (aka RowVersion) data type and the Oracle RowID property.
>
> As I understand it, and I am willing to be corrected by anyone with
superior
> knowledge, the Oracle RowID property is an internal value that allows
Oracle
> to quickly locate the physical location of a row. As such, it is
independent
> of the values contained within the row itself. In other words, one can
issue
> multiple UPDATEs to an Oracle row, and the RowID will not change.
>
> As I'm confident you are aware, an UPDATE to a row containing the
Timestamp
> datatype changes the value of the Timestamp column.
>
> Chief Tenaya
>
>
> "Jaxon" <GregoryAJacksonN0SPAM@hotmail.com> wrote in message
> news:eencRb2DEHA.1240@TK2MSFTNGP10.phx.gbl...
> > SQL Server does support a RowVersion DataType. Most often referred to as
> > TimeStamp.
> >
> > I dont know JACK about Oracle, but I believe this is what you are
looking
> > for.
> >
> >
> > cheers,
> >
> >
> > Greg Jackson
> > PDX, Oregon
> >
> >
>
>

Relevant Pages

  • Re: Simulieren einer Informix - RowID
    ... Diese Adresse stellt zwar gleiches da wie eine ROWID. ... wieviel sie Oracle nachgeahmt haben - das verliess mich bei C-ISAM ... Da sich der SQL Server beim Defragmentieren oder Teilen von Seiten ...
    (microsoft.public.de.sqlserver)
  • Re: Equivalent to rowid in Oracle...
    ... I actually meant to refer to rownum, not rowid - just haven't ... > the SQL Server Timestamp data type. ... RowID actually IS the internal Oracle pointer ... > Server Timestamp is, as was implicit in my first posting, that the SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Converting an Oracle Trigger Script into SQL Server
    ... Wayne Snyder, MCDBA, SQL Server MVP ... STTIME + DURATION from inserted ... > This is assuming that ROWID is a column in the table GCDR and that there ...
    (microsoft.public.sqlserver.programming)
  • Re: XML INTO SQL
    ... CREATE TABLE #tmpFileLines (rowID int IDENTITY, ... And can you assume that rowID is really assigned in the order the rows ... -- This string variable is used with OPENXML ... VBscript that reads the file and connects to SQL Server. ...
    (comp.databases.ms-sqlserver)
Loading