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
i think i found something similar to here
Merge statement is introduced in Sql server 2008, but since you are on SQL Server 2005, you can refer http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html
A Microsoft está realizando uma pesquisa online para saber sua opinião sobre o site Msdn. Se você optar por participar, a pesquisa online lhe será apresentada quando você sair do site Msdn.