Re: How to make a numbering field to a field selection in SQL?

From: Jerry Pisk (jerryiii_at_hotmail.com)
Date: 04/29/04 

Date: Wed, 28 Apr 2004 23:28:17 -0700

NEWID if you don't need those to be sequential numbers. But even if you
number them, there won't be any relevance to anything in the database,
unless you create those numbers in the actual data. Seems like you need to
rethink your design instead of trying to come up with arbitrary record
numbers in a resultset.

Jerry

"Tonya" <anonymous@discussions.microsoft.com> wrote in message
news:6A6B521B-7F8E-460C-9E37-5116B7B3E627@microsoft.com...
> Hi! I have a table in my database, from which I SELECT some fields. Is
there any function in SQL, which can add an artificial field for numbering
my records to the result of the selection?
> Thanks in advance!
>

Relevant Pages

  • Re: Can Access use Fuzzy Logic
    ... random data to a relational database. ... The validity of the data in a rdbms does not guarantee its ... "Relevance" of data was not the subject of this thread... ...
    (comp.databases.ms-access)
  • Re: Totals Query
    ... relevance to this field?? ... There are 20% of everything in the database which are Male ... >>Diffent Colums from diffent table.... ... >>What is the source though what sort of thing would I be ...
    (microsoft.public.access.queries)
  • Re: Can Access use Fuzzy Logic
    ... random data to a relational database. ... "Relevance" of data was not the subject of this thread... ... Access is, in fact, the UI and development tool. ... can be the Jet database engine that comes with Access and is installed by ...
    (comp.databases.ms-access)
  • aspnet vs IUSR_COMPUTERNAME
    ... the web form acts as ASPNET when accessing a database. ... This used to be IUSR_COMPUTERNAME in old asp, so my question is what is the relevance of the anonymous IIS account IUSR_COMPUTERNAME - is it used anywhere in asp.net - should I forget about it? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • How to make a numbering field to a field selection in SQL?
    ... I have a table in my database, from which I SELECT some fields. ... Is there any function in SQL, which can add an artificial field for numbering my records to the result of the selection? ...
    (microsoft.public.data.ado)
Loading