156 results found

1. Align equals sign in UPDATE

   Provide an option in Styles to let the right hand side of clauses in UPDATE statement be aligned.

   Example:

   UPDATE~~EDSV
   SET~~~~~eDocSessionID~~~~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionID~,
   ~~~~~~~~eDocSessionKey~~~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionKey~,
   ~~~~~~~~eDocSessionValue~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionValue~,
   ~~~~~~~~eDocSessionValueTextStyleOverride~=~CONSV.eDocSessionValueTextStyleOverride~,
   ~~~~~~~~eDocSessionValuePositionOverride~~=~CONSV.eDocSessionValuePositionOverride~,
   ~~~~~~~~eDocSessionValueLockdown~~~~~~~~~~=~''
   FROM~~~~eDocStd2.dbo.eDocSessionValues~AS~EDSV
   ~~~~~~~~INNER~JOIN~#changedOrNewSessionValues~AS~CONSV~ON~CONSV.eDocSessionID~=~EDSV.eDocSessionID
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~AND~CONSV.eDocSessionKey~=~EDSV.eDocSessionKey;

   42 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   5 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Create new Setting to only enclose SQL Keywords in square brackets

   I don't want to use brackets for my code (unless I have to). So, for example, dbo.Orders is fine, but dbo.Order isn't. It would be nice if SQL prompt caught this and automatically enclosed the SQL Keyword "Order" in square brackets (i.e. dbo.[Order] AS o)

   47 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Comment Word Wrap

   Hi!

   I would be nice to have the option to enable word wrap for the comments as well.
   The number of maximum characters for the comment should be aligned with "Wrap lines longer than" for SQL statements.

   19 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. End column guide lines

   I think SSMSBoost has this feature: being able to add configurable guide lines to limit the query writing space to a specified number of characters/columns. This is very handy as I always want to keep my code narrow, within the 80-char limit. Currently, I have to install SSMSBoost for it... Could this please be added to SQL Prompt? This is probably a quick feature to implement and would be tremendously useful. Thanks.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words. "Status", "Type",etc.",

   Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words.
   "Status", "description", and "Type" are examples of special words that are syntax highlighted, but they aren't full reserved keywords, so would want the brackets kept.

   How to configure and prevent SQL Prompt from removing brackets around Syntax highlighted words?
   We only have the following settings:
   a) Options > Inserted Code > Special Characters > Brackets > Enclose identifiers within square brackets [] = NO (which is our desire)
   b) Options > Format > Styles > Actions > run format > Add/remove square brackets = YES, remove unnecessary brackets = YES (our desired result)
   BUT, we do not want the square brackets removed from BLUE special syntax highlighted words, of course. How to do this?

   (In SQL Prompt the "remove unnecessary brackets" setting means it'll remove all the brackets that aren't needed to run the script. If you had a fully reserved keyword like While or Table, then the brackets around it would be necessary to run the script.)

   Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words.
   "Status", "description", and "Type" are examples of special words that are syntax highlighted, but they aren't full reserved keywords, so would want the brackets kept.

   How to configure and prevent SQL Prompt from removing brackets around Syntax highlighted words?
   We only have the following settings:
   a) Options > Inserted Code > Special Characters > Brackets > Enclose identifiers within square brackets [] = NO (which is our desire)
   b) Options > Format > Styles > Actions > run format > Add/remove square brackets = YES,… more

   29 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. prevent Prompt SQL from destroying bookmarks

   If format SQL makes chnages - it destroy saved marks
   This occurs even when line bookmarked line hasnt (visibly) changed
   Very frushtrating

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. LINQ Style SQL

   What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).

   The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like LINQ, 2) rearrange current SQL scripts into that same LINQ style formatting, and 3) to translate this new format into standard compliant SQL, before executing and/or saving, within SQL Server Management Studio (SSMS).

   By LINQ style, I mean, where the “from” and “how” (on what and what type of joins are used) is defined first, with the “what” (which columns/entity attributes) last. The conditionals (the WHERE clause) and the standard grouping (the GROUP BY clause) would go between the “from/how” and the “what”.

   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

   What I’m thinking of, is a setting tied to a toggle button on the SQL Prompt toolbar, which turns on/off this new “view”. If the toggle is turned on, the valid syntax would be the LINQ style, allowing for a more natural use of intellisense, and translate before execution and/or saving; if off, SQL Server Management Studio (SSMS) would simply work as it does now. This “view” would simply be another layer (a translator) between the text editor and the execution and/or saving of the SQL script.

   Additional, down the road, benefits:
   I’ve also read a couple different feature request to translate SQL scripts into LINQ and/or Lamda style expressions. This new “view”, or translator layer, could allow for this. A Right-Click, save as or export option could be handled here.

   What I’m proposing, would change the way we type our SQL scripts. I’m not suggesting we try to pass or force through a new SQL standard. I’m simply suggesting a new dynamic “view” of the SQL syntax, which would allow for a more natural support of intellisense. With today’s IDE’s this simply doesn’t work. Intellisense doesn’t know where to pull the “what” from. The “what” comes from the “where”, (the FROM clause).

   The underlying SQL script itself, would still comply with the SQL standards. This “view”, would perform three tasks: 1) allow the end-user to type their SQL more like… more

   11 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Expand a view or views referenced in a query

   I think it would be great if SQL Prompt had the functionality to expand a view that is used in a query. So if you have this schema:
   CREATE TABLE dbo.Person
   (
   PersonID INT IDENTITY(1, 1)
   PRIMARY KEY,
   LastName VARCHAR(30),
   FirstName VARCHAR(30),
   );
   GO

   CREATE TABLE dbo.Student
   (
   StudentID INT IDENTITY(1, 1)
   PRIMARY KEY,
   PersonID INT,
   StudentNo VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.Class
   (
   ClassID INT IDENTITY(1, 1)
   PRIMARY KEY,
   ClassName VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.ClassRoster
   (
   ClassID INT,
   StudentID INT
   );

   GO

   CREATE VIEW dbo.Students
   AS
   SELECT
   S.StudentID,
   P.LastName,
   P.FirstName,
   S.StudentNo
   FROM
   dbo.Person AS P
   JOIN dbo.Student AS S
   ON P.PersonID = S.PersonID;
   GO

   CREATE VIEW dbo.Classes
   AS
   SELECT
   C.ClassID,
   C.ClassName,
   CR.StudentID
   FROM
   dbo.Class AS C
   JOIN dbo.ClassRoster AS CR
   ON C.ClassID = CR.ClassID;
   GO

   Then you have this query:

   SELECT
   S.StudentID,
   S.LastName,
   S.FirstName,
   S.StudentNo,
   C.ClassID,
   C.ClassName,
   C.StudentID
   FROM
   dbo.Students AS S
   JOIN Classes AS C
   ON S.StudentID = C.StudentID;

   You could right-click or have a keyboard combination that say Expand Views and the query becomes:

   SELECT
   S.StudentID,
   S.LastName,
   S.FirstName,
   S.StudentNo,
   C.ClassID,
   C.ClassName,
   C.StudentID
   FROM
   (
   SELECT
   S.StudentID,
   P.LastName,
   P.FirstName,
   S.StudentNo
   FROM
   dbo.Person AS P
   JOIN dbo.Student AS S
   ON P.PersonID = S.PersonID
   ) AS S
   JOIN (
   SELECT
   C.ClassID,
   C.ClassName,
   CR.StudentID
   FROM
   dbo.Class AS C
   JOIN dbo.ClassRoster AS CR
   ON C.ClassID = CR.ClassID
   ) AS C
   ON S.StudentID = C.StudentID;

   I would find this useful when working with third party products or when coming in new to an environment as it would immediately show me the places where there are multiple references to the same table or where a view is providing some layer of filtering that I'm not aware of.

   I think it would be great if SQL Prompt had the functionality to expand a view that is used in a query. So if you have this schema:
   CREATE TABLE dbo.Person
   (
   PersonID INT IDENTITY(1, 1)
   PRIMARY KEY,
   LastName VARCHAR(30),
   FirstName VARCHAR(30),
   );
   GO

   CREATE TABLE dbo.Student
   (
   StudentID INT IDENTITY(1, 1)
   PRIMARY KEY,
   PersonID INT,
   StudentNo VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.Class
   (
   ClassID INT IDENTITY(1, 1)
   PRIMARY KEY,
   ClassName VARCHAR(100)
   );
   GO

   CREATE TABLE dbo.ClassRoster
   (
   ClassID INT,
   StudentID INT
   );

   GO

   CREATE VIEW dbo.Students
   AS
   SELECT
   S.StudentID,
   P.LastName,
   P.FirstName,
   S.StudentNo
   FROM
   dbo.Person AS P
   JOIN dbo.Student AS… more

   16 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   3 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Format SQL Code on opening file

   It would be awsome if there was an option that would format an SQL Script automatically after opening it in SSMS / VS. So if you load a file it would be formatted automatically with your selected formatting style. It would be great too if this auto format option could be switched on and off in the Options.

   17 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Replace all tabs with spaces

    Setting the option to use spaces instead of tabs for intending (our house policy) only works for new tab presses.
    I would like a simple action that would replace all tabs in the current document with spaces -- using the tab-to-spaces value as set in options. Sublime Text has this and I use practically every time I edit anything.

    51 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Format all SQL in an SSDT project.
    14 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Convert code to dynamic Code

    Convert selected CODE or a complete stored procedure to Dynamic SQL Code.

    16 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. Template based formatting with different

    Template based formatting.
    Select your text and right click, format according to template... then select the appropriate template of your choice.

    8 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. Auto generated INSERT needs a column blacklist

    Add the ability to exclude columns from appearing in the auto-generated INSERT statements. I have to manually remove certain columns every time.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Align aliases, commas, datatypes and expressions at the next tab stop

    I align aliases, commas, datatypes and expressions at the first tab stop following the longest element in the list. See examples below:

    -- Tilde character used as space replacement to cope with HTML formatting
    -- 2-character tabs are assumed below
    -- In a fixed-space font, the commas, = signs, data types and AS keywords would all line up vertically
    DECLARE
    ~~@x~~~~~~~~~~~~~~INT~~~~~~~~~,
    ~~@var~~~~~~~~~~~~VARCHAR(4)~~,
    ~~@longer_varname~VARCHAR(10)~,
    ~~@z~~~~~~~~~~~~~~DATETIME~~~~;

    SELECT
    ~~~~@longer_varname~=~'x'~~~~~~~,
    ~~~~@var~~~~~~~~~~~~=~'1234'~~~~,
    ~~~~@z~~~~~~~~~~~~~~=~GETDATE()~;

    SELECT
    ~~~~T1.shortfield~~~~~~~~AS~ShortField~,
    ~~~~AO.reallylongfield~~AS~LongField~~,
    ~~~~'x'~~~~~~~~~~~~~~~~~~~AS~XChar~~~~~~,
    ~~FROM~~~~~~~~dbo.table1~~~~~~AS~T1
    ~~~~LEFT~JOIN~dbo.anotherone~AS~AO~ON~T1.keyval~=~AO.keyval;

    EXEC~@x~=~dbo.SomeProc
    ~~@Param1~=~'3'~~~~~~~~~~~,
    ~~@P2~~~~~=~'Longer~Text'~,
    ~~@P3~~~~~=~4~~~~~~~~~~~~~;

    24 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. warn against data truncation

    I would be nice if SQL-prompt could warn against posible data truncation.
    Like assigning a int value to a tinyint field/variable or assigning a varchar(30) to a varchar(3).
    I want it both at an global analysis (like find invalid objects) and in the current scrip edit (while modifying a trigger / procedure / function).

    13 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close