How can we help you today? How can we help you today?

Not possible to proper format a MERGE statement

Not possible to proper format a MERGE statement.

Please see following snippet:
MERGE [X] AS L
    USING 
        (
          SELECT
                [X]
            FROM
                [X]
            WHERE
                [X] = X
        ) AS SRC
    ON L.ID = SRC.ID
    WHEN MATCHED 
        THEN UPDATE
            SET 
                X.[X] = 'X'
    WHEN NOT MATCHED 
        THEN
INSERT
                
          (
            [Col1],
            [ColX]
          ) VALUES
                (
                  1,
                  X
                );

1) The INSERT keyword has no indent
2) Between INSERT keyword and the first parenthese is one line break too much
3) The VALUES keyword is not on a new line
mspiegel
0

Comments

2 comments

Sort by
  • chriskelly
    Thank you for your post.

    I believe that MERGE is a new feature for SQL Server 2012. While SQL Prompt does support this version, it does not yet support all the new features. So I believe that this is why you are seeing odd behaviour.

    I have therefore logged a report on our bug tracking system for the development team to take a look at.
    chriskelly
    0
  • mspiegel
    Thanks for the info.

    Actually the MERGE statements exists in SQL Server since 2008.


    Cheers
    mspiegel
    0

Add comment

Please sign in to leave a comment.