Post reply

Record number for sql server 2000

  • July 14, 2003 at 12:42 pm

    #101569

    HI. I was given a conversion report by a software vendor telling data errors on the sql server data. the report reads RECORD 12532 of table EMP_TABLE has an invalid date. Is there a quick and easy way to find that particular record? I didn't know if in sql server you can run a query to retrieve a record by it's location in the file with a record number or something similiar.

    Thanks!

    Juanita

  • July 14, 2003 at 1:13 pm

    #465424

    Sounds unusual but run

    SELECT TOP 12532 * FROM table_name and look at the last row.

    By the way, if you have a clustered index on that table, rows are physically sorted by that index. If you don't, they go in the order of their insertion or last update.

  • July 14, 2003 at 1:17 pm

    #465427

    quote:

    SELECT TOP 12532 * FROM table_name and look at the last row.

    By the way, if you have a clustered index on that table, rows are physically sorted by that index. If you don't, they go in the order of their insertion or last update.

    You should check for the index they have used for convertion.

    If they have used an index add the columns of that index to mromm's query.

    G.R. Preethiviraj Kulasingham

    Chief Technology Officer.

    Softlogic Information Systems Limited,

    14 De Fonseka Place,

    Colombo 05.

    Sri Lanka.

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/

  • July 14, 2003 at 1:19 pm

    #465428

    Thanks so much.. I just gave it a try and I think that will work.

    Thanks again!

    Juanita

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply