You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
My intuition is this should probably parse (e.g. in SQL Server), but doesn't:
MERGE INTO balance
USING (
VALUES (1, 2.50), (2, 3.50), (13, 8.30)
) AS s (i, b)
ONbalance.id=s.iANDbalance.balance=s.b
WHEN MATCHED THEN UPDATESET balance = b
The error is:
Keyword 'ON' expected: [4:8] ...
VALUES (1, 2.50), (2, 3.50), (13, 8.30)
) AS s [*](i, b)
ON balance.id = s.i
AND balance.balance = s.b
WHEN MATCHED THEN UPDATE S...
My intuition is this should probably parse (e.g. in SQL Server), but doesn't:
The error is:
From https://stackoverflow.com/a/62879490/521799
The text was updated successfully, but these errors were encountered: