Is there an option in SQL Prompt Styles to format the Merge statements

DominicV

Is there an option in SQL Prompt Styles to format the Merge statements like below:

From:

  MERGE dbo.TableName AS TARGET

  USING

    (

      SELECT

        @ScheduleId ScheduleId,

        @AgreementID AgreementID

    ) AS SOURCE

  ON (TARGET.ID = SOURCE.ScheduleId)

  WHEN MATCHED THEN UPDATE SET

                      TARGET.AgreementID = SOURCE.AgreementID,

                      TARGET.ScheduleName = SOURCE.ScheduleName

  WHEN NOT MATCHED BY TARGET THEN

    INSERT

      (

        AgreementID,

        ScheduleName

      )

    VALUES

      (

        SOURCE.AgreementID,

        SOURCE.ScheduleName

      );


TO:

  MERGE dbo.TableName AS TARGET

  USING

    (

      SELECT

        @ScheduleId ScheduleId,

        @AgreementID AgreementID

    ) AS SOURCE

  ON (TARGET.ID = SOURCE.ScheduleId)

  WHEN MATCHED
    THEN UPDATE SET

      TARGET.AgreementID = SOURCE.AgreementID,

      TARGET.ScheduleName = SOURCE.ScheduleName

  WHEN NOT MATCHED BY TARGET 

    THEN INSERT

      (

        AgreementID,

        ScheduleName

      )

    VALUES

      (

        SOURCE.AgreementID,

        SOURCE.ScheduleName

      );

Dimitry

the same question 

dplaut

It would be great if SQL Prompt created a merge statement with all of the fields from the source, especially the set statements, e.g. Set Field1 = source.Field1

jonasgunnarsson

This would be good, now it's get wide and ugly. Option, new line after then, would be nice.

when not matched then
    insert (
        X
        ,Y
    )
    values
    (@x, @y)