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

From: Tonya (anonymous_at_discussions.microsoft.com)
Date: 04/28/04

  • Next message: Terry: "-2147467259 Unspecified Error" 
    Date: Wed, 28 Apr 2004 09:51:11 -0700

    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!

  • Next message: Terry: "-2147467259 Unspecified Error"

    Relevant Pages

    • An artificial field for numbering records.
      ... 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.sqlserver.programming)
    • Re: How to make a numbering field to a field selection in SQL?
      ... number them, there won't be any relevance to anything in the database, ... rethink your design instead of trying to come up with arbitrary record ... I have a table in my database, from which I SELECT some fields. ... which can add an artificial field for numbering ...
      (microsoft.public.data.ado)
    • Re: Mixing linq to sql and linq to xml (in linqpad)
      ... I would like to filter my xml data, when it contains a item attribute ... ....except that neither of these work if "myTable" is an actual SQL table, because LINQ to SQL can't handle XML methods. ... you could factor out the XML selection logic to the database. ... The obvious drawback to this method is that you need to carefully work out your data needs in advance as far as the SQL selection is concerned. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Application logic and Business logic
      ... OQL is heavily based on SQL and relational calculus ... > (selection, projection, joins, etc). ... It would be impossible for a network database to execute ...
      (comp.object)