Insert Statement

Question

Hai all.... I want to insert a data into the database only if the data is not present already.... If it is i'll just skip the insert statement........ How am i go about it.............

Vijaya Kadiyala · Answer

Hi With MERGE you can avoid lot of coding around this. Yes simple thing is using Select but you need to place this logic in T-SQL block in order meet his requirement. If we go with MERGE then its not required to have it in T-SQL. Thanks Vijaya Kadiyala Http :// dotnetvj . blogspot . com

Lisa · Answer

why complicating using merge you can always check for the record in the database based on id name ... if found leave it else insert into the database Thanks Lisa

Len La Sala · Answer

A simple way is to check the existance of a record SELECT name country FROM customer WHERE name='name' AND country=country' use as many fields as you like for the comparison if the query returns 0 records the data does not exist so you can then do your insert. Just another way to do it

Vijaya Kadiyala · Answer

Hi Check out the below link http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html Thanks Vijaya Kadiyala http :// dotnetvj . blogspot . com

Vijaya Kadiyala · Answer

Hi Check out the below link http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html Thanks Vijaya Kadiyala http :// dotnetvj . blogspot . com

krishna prasad · Answer

Thanks for the reply man....... But i beleive the option is for sql server 2008....But i am using sql server 2005..... How am i go about it.........

Vijaya Kadiyala · Answer

You can use MERGE feature of SQL Server Check out the below link http://www.sqlservercurry.com/2008/05/sql-server-2008-merge-statement.html Thanks -- VJ