Top "Upsert" questions

For issues relating to performing upsert (combination update/insert) operations.

Insert Update stored proc on SQL Server

I've written a stored proc that will do an update if a record exists, otherwise it will do an insert. …

sql sql-server stored-procedures upsert
MongoTemplate upsert - easy way to make Update from pojo (which user has editted)?

Here is a simple pojo: public class Description { private String code; private String name; private String norwegian; private String english; } …

java mongodb upsert mongotemplate
syntax for single row MERGE / upsert in SQL Server

I'm trying to do a single row insert/update on a table but all the examples out there are for …

sql-server merge upsert
How to correctly do upsert in postgres 9.5

correct syntax of upsert with postgresql 9.5, below query shows column reference "gallery_id" is ambiguous error , why? var dbQuery = `INSERT …

sql postgresql upsert postgresql-9.5
How do I Insert or Update (or overwrite) a record using NHibernate?

I need to write a row to the database regardless of whether it already exists or not. Before using NHibernate …

nhibernate insert-update overwrite upsert
How can I use use Entity Framework to do a MERGE when I don't know if the record exists?

In this SO answer about Entity Framework and MERGE, the example for how to code it is this: public void …

.net entity-framework entity-framework-6 upsert
How to upsert with mongodb-java-driver

How can I upsert data into mongodb collection with java-driver? I try (with empty collection): db.getCollection(collection).update(new …

java mongodb upsert
how to load data faster with talend and sql server

I use Talend to load data into a sql-server database. It appears that the weakest point of my job is …

sql-server database-performance talend upsert
Postgres UPSERT (INSERT or UPDATE) only if value is different

I'm updating a Postgres 8.4 database (from C# code) and the basic task is simple enough: either UPDATE an existing row …

sql postgresql merge upsert
MongoDb upsert exception invalid BSON field

This exception: Exception in thread "Thread-1" java.lang.IllegalArgumentException: Invalid BSON field name id at org.bson.AbstractBsonWriter.writeName(AbstractBsonWriter.…

java mongodb upsert