Home Forums SQL Server 2005 SQL Server Newbies Order of rows in a Table with Identity Column. RE: Order of rows in a Table with Identity Column.

  • July 2, 2013 at 6:27 am

    #1629029

    The only way to guarantee order you must use an ORDER BY clause in your query. SQL Server will not guarantee the order of the data otherwise.

    +1

    Set theory does not guarantee the order of a result set. The only way to guarantee it is with an order by clause (or have your app sort the results).

    Joie Andrew
    "Since 1982"