Skip to content

Settings and activity

1 result found

  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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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  ·