Skip to content
← Customer Feedback for Redgate

Settings and activity

1 result found

  1. LINQ Style SQL

    11 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  SQL Prompt » Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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  ·