Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to T-SQL DML Level 12: Using the MERGE Statement RE: Stairway to T-SQL DML Level 12: Using the MERGE Statement

  • January 16, 2013 at 9:23 am

    #1577896

    In reply to paul.barbin

    I have had exactly the opposite experience and i like the syntax of it.

    We used MERGE, EXCEPT and INTERSECT in a few ad-hoc queries and sproc ammendments with excellent results. The last time we used merge the operation performed nearly 50 million inserts in a matter of minutes.