activerecord-sqlserver-adapter
activerecord-sqlserver-adapter copied to clipboard
Check if insert_all/upsert_all can be implemented using MERGE
Issue
Rails 6 introduced upsert_all and the SQL Server adapter does not implement it yet.
There's no such thing as MySQL's ON DUPLICATE KEY UPDATE in SQL Server, but we could possibly use the MERGE clause to achieve the same result.
Expected behavior
upsert_all and insert_all could possibly be implemented using MERGE.
Actual behavior
upsert_all and insert_all are not implemented.
@wpolicarpo I created PR https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/pull/869 to explore this possibility. I found some issues.