Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE

by

I was surprised that none of the answers on this page contained an example of an actual query, so here you go:

A more complex example of inserting data and then handling duplicate 

MERGE
INTO MyBigDB.dbo.METER_DATA WITH (HOLDLOCK) AS target
USING (SELECT
    77748 AS rtu_id
   ,'12B096876' AS meter_id
   ,56112 AS meter_reading
   ,'20150602 00:20:11' AS local_time) AS source
(rtu_id, meter_id, meter_reading, time_local)
ON (target.rtu_id = source.rtu_id
  AND target.time_local = source.time_local)
WHEN MATCHED
  THEN UPDATE
      SET meter_id = '12B096876'
         ,meter_reading = 56112
WHEN NOT MATCHED
  THEN INSERT (rtu_id, meter_id, meter_reading, time_local)
      VALUES (77748, '12B096876', 56112, '20150602 00:20:11');

More Related Contents:

  1. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  2. Equivalent of MSSQL IDENTITY Column in MySQL
  3. SQL Query needed for fetch value from Two identical table but not fully identical table
  4. Calculate Average of the largest values in multiple columns
  5. SQL Print the name of all Employees together with the name of their supervisor
  6. Storing JSON in database vs. having a new column for each key
  7. MySQL LIMIT clause equivalent for SQL SERVER
  8. SQL: Repeat a result row multiple times, and number the rows
  9. How to export SQL Server database to MySQL? [duplicate]
  10. sql join two table
  11. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  12. How to transform a MSSQL CTE query to MySQL?
  13. Is there a Profiler equivalent for MySql? [closed]
  14. Why do results from a SQL query not come back in the order I expect?
  15. When to use SELECT … FOR UPDATE?
  16. Relationship between catalog, schema, user, and database instance
  17. Import MySQL database into a SQL Server
  18. How to export data from SQL Server 2005 to MySQL [closed]
  19. MySQL Aggregate Functions without GROUP BY clause
  20. mysql equivalent data types
  21. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  22. How to migrate SQL Server database to MySQL? [closed]
  23. how to cast the hexadecimal to varchar(datetime)?
  24. How to import a SQL Server .bak file into MySQL?
  25. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  26. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  27. What are the max number of allowable parameters per database provider type?
  28. Why in SQL NULL can’t match with NULL?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment