Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Compare two Table data and insert changed field to the third table RE: Compare two Table data and insert changed field to the third table

  • August 29, 2014 at 2:56 am

    #1741828

    thanks everybody

    also I try this code and this is working fine

    insert into diff

    select *

    from (

    select *

    from c1

    except

    select *

    from c2

    ) as T