Home Forums SQL Server 2008 T-SQL (SS2K8) Using Merge to insert data but failed RE: Using Merge to insert data but failed

  • November 18, 2016 at 2:16 am

    #1913347

    DesNorton (11/18/2016)

    Deny Christian (11/18/2016)

    So, it will take only 1 data if there are 3 data at the Source ?

    The MERGE statement will take all of the data that you provide it.

    However, you need to make sure that you only give it the data that will not break the rules of the destination table. That could be Primary Key, Unique Index, Check Constraint, etc

    noted then,,thank you for your help.