Click here to monitor SSC

table comparison in sql through python

Last post 06-02-2009, 12:40 AM by baghel_ramdas. 1 replies.
Sort Posts: Previous Next
  •  06-01-2009, 11:03 AM Post number 73618

    • k38 is not online. Last active: 06-01-2009, 11:05 AM k38
    • Not Ranked
    • Joined on 06-01-2009
    • Level 1: Deep thought

    table comparison in sql through python

    hi have to parse a very complex dumps(whatever it is), i have done the parsing thruogh python.since the parsed data is very huge in amount, i have to feed it in the database (SQL), I have also done this... now the thing is i have to compare the data now present in the sql.

     

    in actual i have to compare the data of 1st dump with the data of the 2nd dump..... the both dump have the same fields(attributes) but the values of their field may be change... so i have to detect this change.. for this i have to do the comparison...

     

    i.e, let i have a tableA ,its 1st row carry the data of dump1 and then on the 2nd day the data comes from dump2 go into the next row of tableA. and i have to compare both rows. 

     

     but i dont have the idea how to do this all using python as my front end.

     

    plz plzzzz anyone help me:(

  •  06-02-2009, 12:40 AM Post number 73630 in reply to post number 73618

    Re: table comparison in sql through python

    Hi!

    You need to use CHECKSUM T-SQL keyword to compare Hole Table, Single Row or Selected Filed. whatever u want.

    More Detail see
    http://www.mssqltips.com/tip.asp?tip=1023

    Thanks
    Ramdas Singh
    MCDBA
View as RSS news feed in XML