The best way to compare fields

  • There about 25 fields in one table. The fields's name like below.

    A, A_NEW, B, B_NEW...and so on.

    All data in Fields which named without _NEW is stored data from OrderHistory table and with _NEW stored the data from application user's input.

    Is there any fast way to compare data A with A_NEW, B with B_NEW and so on.

    As long as find out a difference from any pair, just send out message.

  • You can use system objects about the table/columns to write a query that will write the comparison query for you. Easy-peasy, lemon-squeezy!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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