INSERT INTO TOP ROW?

[Sharon]

Hi everyone!
Do you know how to write either ASP or stored procedure to insert a record
into the table? I WOULD LIKE TO SEE THE INSERT INTO THE TOP ROW NOT THE BOTTOM
ROW OF THE table. By convention, if you are trying to insert something into
table, it will insert into the bottom row. I would like it to insert to the
top row instead.

Thank you!
Sharon

[Arthur Wood]

Sharon,

The concept of LAST ROW or TOP ROW does not have any real significance
in a standard Relational Database. Why do you THINK that it is important
to "INSERT INTO THE TOP ROW"?

In general, you have no control at all over the ABSOLUTE location of any
particualr record in the database.

Arthur Wood

"Sharon" <sharongarg@yahoo.com> wrote:
>
>Hi everyone!
>Do you know how to write either ASP or stored procedure to insert a record
>into the table? I WOULD LIKE TO SEE THE INSERT INTO THE TOP ROW NOT THE
BOTTOM
>ROW OF THE table. By convention, if you are trying to insert something
into
>table, it will insert into the bottom row. I would like it to insert to
the
>top row instead.
>
>Thank you!
>Sharon

[Willy Van den Driessche]

That's right, if you do want control over that, you have to use the order by
clauses.
BTW, I think you want it in the top row of your grid, which would depend on
the capabilities of the grid you are using. -Willy

"Arthur Wood" <wooda@saic-trsc.com> wrote in message
news:3b378585$1@news.devx.com...
>
> Sharon,
>
> The concept of LAST ROW or TOP ROW does not have any real significance
> in a standard Relational Database. Why do you THINK that it is important
> to "INSERT INTO THE TOP ROW"?
>
> In general, you have no control at all over the ABSOLUTE location of any
> particualr record in the database.
>
> Arthur Wood
>
> "Sharon" <sharongarg@yahoo.com> wrote:
> >
> >Hi everyone!
> >Do you know how to write either ASP or stored procedure to insert a
record
> >into the table? I WOULD LIKE TO SEE THE INSERT INTO THE TOP ROW NOT THE
> BOTTOM
> >ROW OF THE table. By convention, if you are trying to insert something
> into
> >table, it will insert into the bottom row. I would like it to insert to
> the
> >top row instead.
> >
> >Thank you!
> >Sharon
>

[Matthew Solnit]

"Arthur Wood" <wooda@saic-trsc.com> wrote in message
news:3b378585$1@news.devx.com...
> The concept of LAST ROW or TOP ROW does not have any real significance
> in a standard Relational Database. Why do you THINK that it is important
> to "INSERT INTO THE TOP ROW"?

I agree that it doesn't make sense. But for educational purposes... couldn't
this be done using a clustered index?

-- Matthew Solnit

[Arthur Wood]

That would ONLY apply to SQL Server databases, and even then, for what purpose?

Arthur Wood


"Matthew Solnit" <msolnit@nospam.yahoo-com> wrote:
>"Arthur Wood" <wooda@saic-trsc.com> wrote in message
>news:3b378585$1@news.devx.com...
>> The concept of LAST ROW or TOP ROW does not have any real significance
>> in a standard Relational Database. Why do you THINK that it is important
>> to "INSERT INTO THE TOP ROW"?
>
>I agree that it doesn't make sense. But for educational purposes... couldn't
>this be done using a clustered index?
>
>-- Matthew Solnit
>
>

[Matthew Solnit]

"for educational purposes"

I've just been educated in the study of clustered indexes being specific to SQL
Server.

;-)

"Arthur Wood" <wooda@saic-trsc.com> wrote in message
news:3b3891ea@news.devx.com...
>
> That would ONLY apply to SQL Server databases, and even then, for what
purpose?
>
> Arthur Wood
>
>
> "Matthew Solnit" <msolnit@nospam.yahoo-com> wrote:
> >"Arthur Wood" <wooda@saic-trsc.com> wrote in message
> >news:3b378585$1@news.devx.com...
> >> The concept of LAST ROW or TOP ROW does not have any real significance
> >> in a standard Relational Database. Why do you THINK that it is important
> >> to "INSERT INTO THE TOP ROW"?
> >
> >I agree that it doesn't make sense. But for educational purposes... couldn't
> >this be done using a clustered index?