none
Sql server 2005 - sql - insert based on if.

    Pergunta

  • 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

    domingo, 8 de janeiro de 2012 04:07

Respostas

  •  

    i think i found something similar to here

     

    http://stackoverflow.com/questions/639854/check-if-a-row-exists-otherwise-insert

     

    thanks anyway

    • Marcado como Resposta WPHC domingo, 8 de janeiro de 2012 04:46
    domingo, 8 de janeiro de 2012 04:46

Todas as Respostas