SQL Server Performance

PROBLEM

Discussion in 'ALL SQL SERVER QUESTIONS' started by immad, Jun 29, 2013.

  1. immad Member

    DEAR ALL,

    i want to insert a select query data into a table and if i run again this query then if data already exists in table then data not insert can u show me the syntax

    CAN ANY ONE HELP ME OUT
  2. FrankKalis Moderator

    Couple of way to achieve that:
    * INSERT INTO ... SELECT .... WHERE NOT EXISTS()
    * MERGE
    Make sure you read the online manual for those constructs to understand the implications of each approach.

Share This Page