Sql server 2005 - sql - insert based on if.


  • To whom it may concern,

    Thank you for taking the time to read this and possibly respond.


    I wish to be able to check to see if a row exists with certain values and if it doesnt then insert the record.


    Im currently trying to avoid 2 connections to the database

    1 to see if the row exists

    2 then insert if necessary


    What I wish to do is to be able to do this in a single connection instance to the db


    Thanks heaps

    Sonntag, 8. Januar 2012 04:07



    i think i found something similar to here



    thanks anyway

    • Als Antwort markiert WPHC Sonntag, 8. Januar 2012 04:46
    Sonntag, 8. Januar 2012 04:46

Alle Antworten