Settings and activity

  1. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Prompt » Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Randel Bjorkquist commented  · 

    SQL Example Format Update (I didn't realize the forum engine manipulates whitespaces):

    I would like to be able to type this and have intellisense work normally:
    .
    FROM Order O
    .
    ..JOIN OrderLine OL
    ....ON O.ID = OL.OrderID
    .
    ..JOIN Item I
    ....ON OL.ItemID = I.ID
    .
    ..JOIN Customer C
    ....ON OL.CustomerID = C.ID
    .
    SELECT
    ...C.Name
    ..,I.Descrption
    ..,OL.Quantity
    ..,OL.Price
    ..,(OL.Quantity * OL.Price) “Cost”
    ..,O.Number

    The transformed SQL script would be:
    .
    SELECT
    ...C.Name
    ..,I.Descrption
    ..,OL.Quantity
    ..,OL.Price
    ..,(OL.Quantity * OL.Price) “Cost”
    ..,O.Number
    .
    FROM Order O
    .
    ..JOIN OrderLine OL
    ....ON O.ID = OL.OrderID
    .
    ..JOIN Item I
    ....ON OL.ItemID = I.ID
    .
    ..JOIN Customer C
    ....ON OL.CustomerID = C.ID

    Randel Bjorkquist supported this idea  · 
    Randel Bjorkquist shared this idea  ·