Skip to content

[FORMATTING] Line break at OUTPUT for SQL server #888

Description

@jaredromano

Input data

UPDATE op
SET
    CalculatorCorporationProductQuoteId = ptu.OriginalCalculatorCorporationProductQuoteId 
OUTPUT inserted.Id,
    inserted.ProductId,
    deleted.CalculatorCorporationProductQuoteId,
    inserted.CalculatorCorporationProductQuoteId,
    inserted.OrderId
INTO
    @UpdatedOrderProducts
FROM
    OrderProduct op
    INNER JOIN ProductsToUpdate ptu ON op.Id = ptu.Id
;

Expected Output

UPDATE op
SET
    CalculatorCorporationProductQuoteId = ptu.OriginalCalculatorCorporationProductQuoteId 
OUTPUT inserted.Id,
    inserted.ProductId,
    deleted.CalculatorCorporationProductQuoteId,
    inserted.CalculatorCorporationProductQuoteId,
    inserted.OrderId
INTO
    @UpdatedOrderProducts
FROM
    OrderProduct op
    INNER JOIN ProductsToUpdate ptu ON op.Id = ptu.Id
;

Actual Output

UPDATE op
SET
    CalculatorCorporationProductQuoteId = ptu.OriginalCalculatorCorporationProductQuoteId OUTPUT inserted.Id,
    inserted.ProductId,
    deleted.CalculatorCorporationProductQuoteId,
    inserted.CalculatorCorporationProductQuoteId,
    inserted.OrderId
INTO
    @UpdatedOrderProducts
FROM
    OrderProduct op
    INNER JOIN ProductsToUpdate ptu ON op.Id = ptu.Id
;

Usage

  • How are you calling / using the library? : format on save
  • What SQL language(s) does this apply to? SQL server
  • Which SQL Formatter version are you using? 4.2.2

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions