none
If exist update, else insert RRS feed

  • Question

  • I want to insert record if corresponding record and update if existing record.

    To check if corresponding record exists, which way is faster?

    Should I use SELECT query? 

    Can I use IF EXIST like following?

        IF EXIST(SELECT * FROM.....)

             UPDATE .....

        ELSE

             INSERT ......

    Friday, May 18, 2018 11:10 PM

All replies