Re: INSERT at a particular position?
From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 11/02/04
- Next message: Kalen Delaney: "Re: IN LIKE ??"
- Previous message: Kalen Delaney: "Re: Row Order"
- In reply to: Mal .mullerjannie_at_hotmail.com>: "RE: INSERT at a particular position?"
- Next in thread: Mike John: "Re: INSERT at a particular position?"
- Reply: Mike John: "Re: INSERT at a particular position?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 2 Nov 2004 12:13:35 -0600
> I'm upset about the stance of people when one ask questions that might
seem
> stupid. Only the wise person knows that he really knows nothing.
There is a lot of this. Don't let it upset you. Here in the land of the
unmoderated newsgroup on the world wild web, you ask a question and there
are no warranties, either expressed or implied.
> Every tiger no matter how fierce once had it's infancy.
As long as the infant tiger tries to learn it is a good thing. Some
teachers lose patience and start shooting first, asking questions later.
Bah!
-- ---------------------------------------------------------------------------- Louis Davidson - drsql@hotmail.com SQL Server MVP Compass Technology Management - www.compass.net Pro SQL Server 2000 Database Design - http://www.apress.com/book/bookDisplay.html?bID=266 Note: Please reply to the newsgroups only unless you are interested in consulting services. All other replies may be ignored :) "Mal .mullerjannie@hotmail.com>" <<removethis> wrote in message news:34E9580D-64D3-4495-A85E-1E48FC51CAC6@microsoft.com... > Greg there's many ways to "mimic" this effect, one of them doing order by but > as the others so fondly put it. SQL just store values in row without any > particular order. > > You can create a view of your table where you specify the order by so if you > do queries on the view it will seem like it's stored in a specific order. > > I'm upset about the stance of people when one ask questions that might seem > stupid. Only the wise person knows that he really knows nothing. > > Every tiger no matter how fierce once had it's infancy. > > > "Greg" wrote: > > > Hi, I'm trying to insert a record into a particular position in a table. Is > > this possible?? > > > > It's so I can get records without using ORDER BY - as I want them in an > > order that is nothing to do with the data! I would put a "position" field in > > and order them by that, but I'm thinking if I can insert a record at the > > required position it won't be as much work! :) > > > > Let me know if I'm being an idiot! :) > > > > Thanks, > > Greg > > > > > >
- Next message: Kalen Delaney: "Re: IN LIKE ??"
- Previous message: Kalen Delaney: "Re: Row Order"
- In reply to: Mal .mullerjannie_at_hotmail.com>: "RE: INSERT at a particular position?"
- Next in thread: Mike John: "Re: INSERT at a particular position?"
- Reply: Mike John: "Re: INSERT at a particular position?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
