Insert Statement

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

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

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

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

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

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.........

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