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

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

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
      );


DominicV
0

Comments

3 comments

Sort by
  • Dimitry
    the same question
    Dimitry
    0
  • 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
    dplaut
    0
  • 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)

    jonasgunnarsson
    0

Add comment

Please sign in to leave a comment.