Re: Record , Row number

Let's get back to the basics of an RDBMS. Rows are not records; fields
are not columns; tables are not files; there is no sequential access or
ordering in an RDBMS, so "first", "next" and "last" are totally
meaningless. If you want an ordering, then you need to havs a column
that defines that ordering. You must use an ORDER BY clause on a
cursor -- the keys have nothing whatsoever to do with the display in
the front end.

You have missed the WHOLE POINT of RDBMS. Please stop writing code
until you know what you are doing.

.

Relevant Pages

  • Re: How to find first not null value in column
    ... Let's get back to the basics of an RDBMS. ... Next, you are talking about SQL as if you were in a file system, where ... WHERE klugger IS NULL ...
    (comp.databases.ms-sqlserver)
  • Re: Select all odd/even records.
    ... Let's get back to the basics of an RDBMS. ... are not columns; tables are not files; there is no sequential access or ... Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: id record for each table
    ... relational model. ... Let's get back to the basics of an RDBMS. ... all SQL product use physically contigous storage). ... Please get any basic intro book on RDBMS and read it. ...
    (microsoft.public.sqlserver.programming)
  • Re: multiple values
    ... Let's get back to the basics of an RDBMS. ... hunting for kludges. ...
    (microsoft.public.sqlserver.programming)
  • Re: Row sequence number
    ... Let's get back to the basics of an RDBMS. ... are not columns; tables are not files; there is no sequential access or ... cursor or in an OVERclause. ... You are making a fool of yourself by not knowing the basics. ...
    (comp.databases.ms-sqlserver)