Skip to content

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

@jaredromano

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions