Sequelize upsert when using sql server

Question

can somebody tell me if a sequelize upsert works in sql server? I'm using, specifically, sql server version 2012.

I'm confused because, in the sequelize docs, they state implementation details for:

MySQL, PostgresSQL and SQLite, but not include sql server in the list.

So, I'm curious if it is posible to do an upsert when using sql server (2012).

Answer 1

UPSERT is now supported on MSSQL using MERGE statement

http://docs.sequelizejs.com/manual/tutorial/upgrade-to-v4.html

Answer 2

It's work on MSSQL, I've used upsert on my expressJs that using MSSQL as database. You can see that here