the following MERGE query is working fine out of SQL Management Studio (11.0.6248.0; SQL Server 2012) but throws an error when executed in HeidiSQL portable (9.4 & 22.214.171.12474).
MERGE INTO Cube.dbo.MergeDB AS MDB USING (VALUES ('AAA','BBB')) AS X ([A],[B]) ON (MDB.[WertA] = X.[A] AND MDB.[WertB] = X.[B]) WHEN NOT MATCHED BY TARGET THEN INSERT (WertA,WertB) VALUES (X.[A],X.[B]) OUTPUT $action, inserted.*;
/* SQL Error (10713): A MERGE statement must be terminated by a semi-colon (;) */ /* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 1 query: 0,000 sec. */
I think it the same problem reported by itaysk: .../forum.php?t=20928.
The query is not part of any stored function/procedure/trigger. It is executed on it's own.
Any hints would be highly appreciated :-) Thank you!