Post reply

Compare Data between two table

  • June 5, 2012 at 3:11 am

    #262447

    hi

    i need script or function or procedure to get field's name has data difference and get this data

    which the tables have same fields

    Example:

    tableA

    code name sector

    1 Jone 1

    tableB

    code name sector

    1 Jone 3

    gave me

    field is sector

    data tableA's filed 1

    data tableB's filed 3

  • June 5, 2012 at 3:46 am

    #1496947

    Do you have PK in the table? If yes, you can use TABLEDIFF.EXE command line utitly. It comes with SQL Server.

  • June 5, 2012 at 3:51 am

    #1496948

    but this script run in sql server 2000 ,Is sql 2000 has diffdata.exe utility ?

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

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