Hi, I'm getting this error no matter what:
SQL Error (10713): A MERGE statement must be terminated by a semi-colon (;). The same exact statement works in a different client.
Here is the query:
MERGE Links AS target
USING (SELECT @Url,@Title,@Description,@Tags) AS source (Url,Title,Description,Tags)
ON (target.Url = source.Url)
WHEN MATCHED THEN
UPDATE SET Title=@Title, Description = @Description, Tags = @Tags, Modified = GETDATE()
WHEN NOT MATCHED
THEN INSERT (Title,Description,Url,Tags) VALUES (@Title,@Description,@Url,@Tags) OUTPUT inserted.Id;
Heidi SQL version 9.3.0.4984