Support for MERGE statement

Hi pmscorca ,

 

You are right, it seems ot be a current limitation:

T-SQL surface area - Microsoft Fabric | Microsoft Learn

 

However, you might be able to use another syntax than the merge statement, e.g. the code below:

MERGE INTO target_table AS target
USING source_table AS source
ON target.id = source.id
WHEN MATCHED THEN
    UPDATE SET 
        target.col1 = source.col1,
        target.col2 = source.col2
WHEN NOT MATCHED THEN
    INSERT (id, col1, col2)
    VALUES (source.id, source.col1, source.col2);

 

translates to:

UPDATE target_table
SET 
    target_table.col1 = source_table.col1,
    target_table.col2 = source_table.col2
FROM source_table
WHERE target_table.id = source_table.id; 

INSERT INTO target_table (id, col1, col2)
SELECT source_table.id, source_table.col1, source_table.col2
FROM source_table
LEFT JOIN target_table
ON source_table.id = target_table.id
WHERE target_table.id IS NULL; 

 

Let me know, if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/