Here's my query:
这是我的查询:
MERGE INTO [payments_orders] o USING (
SELECT 1 AS [order_id], 50.00 AS [amount] UNION ALL
SELECT 2 AS [order_id], 50.00 AS [amount]
) AS t ([order_id], [amount])
ON o.[payment_id] = 4 AND o.[order_id] = t.[order_id]
WHEN MATCHED THEN UPDATE SET o.[amount] = t.[amount]
WHEN NOT MATCHED THEN INSERT ([payment_id], [order_id], [amount])
VALUES (4, t.[order_id], t.[amount])
WHEN NOT MATCHED BY SOURCE AND o.[payment_id] = 4 THEN DELETE
OUTPUT $ACTION AS [action], [deleted].[order_id];
MERGE INTO [paymen