674 results found

1. AND keyword for WHERE and JOINs on new line

   There is no option in CLAUSES > JOIN to place AND on new line (Right aligned to INNER) and in Data (DML) there isn't an option to put AND on new line. Lots of tables I join on I am joining on 2 columns and I prefer to have the AND a.col1 = b.col1 on a new line as well.

   4 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

   Submit Rating

2. SQL Prompt -> Tab History -> add datetime stamp column

   Currently it shows the filename and servername, but it would really help to have the datetime of when it was executed. Sorting the columns would be an added benefit as well.

   4 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  ·  Tab history  ·  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

   Submit Rating

3. Inconsistently Advised to Use Alias For CTE (ST010)

   Simple statements do not flag this:

   WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable)
   SELECT a.TestColumn FROM CTE1 a
   INNER JOIN CTE1 b ON a.TestColumn = b.TestColumn;

   However, more complex statements do:

   WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable),
   CTE2 AS (SELECT TestColumn FROM CTE1),
   CTE3 AS (SELECT TestColumn FROM CTE2)
   SELECT CTE3.TestColumn FROM CTE3
   INNER JOIN CTE2 ON CTE3.TestColumn = CTE2.TestColumn;

   In the final select clause, both CTE2 and CTE3 are flagged with 'Use alias for all table sources' (ST010).

   Seems a bit OTT to suggest references to CTEs are aliased? I accept that a CTE defines, in relational terms, a 'table'. However, to me, this smells like obfuscation. Happily use aliases for table/view names though not SQL Prompt's auto alias facility. Both my table aliases and CTE names are typically very short.

   If flagging 'Use alias for all table sources' for CTEs is appropriate consider:
   1. Separate flagging of CTEs and tables/views into different conditions.
   2. Be consistent about CTE aliasing?

   Thanks

   Simple statements do not flag this:

   WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable)
   SELECT a.TestColumn FROM CTE1 a
   INNER JOIN CTE1 b ON a.TestColumn = b.TestColumn;

   However, more complex statements do:

   WITH CTE1 AS (SELECT TestColumn FROM dbo.TestTable),
   CTE2 AS (SELECT TestColumn FROM CTE1),
   CTE3 AS (SELECT TestColumn FROM CTE2)
   SELECT CTE3.TestColumn FROM CTE3
   INNER JOIN CTE2 ON CTE3.TestColumn = CTE2.TestColumn;

   In the final select clause, both CTE2 and CTE3 are flagged with 'Use alias for all table sources' (ST010).

   Seems a bit OTT to suggest references to CTEs are aliased? I accept that a CTE defines, in relational terms,… more

   4 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  ·  Code Analysis  ·  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

   Submit Rating

4. Show SELECT INTO within the Summarize Script pane

   Within the Summarize Script pane, it would be helpful to differentiate between a SELECT statement (which returns output to the user) and a SELECT INTO statement (which creates a table and loads data into it).

   4 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  ·  Summarize script  ·  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

   Submit Rating

5. MS_Description supporting hyperlink when SQL Prompt is showing the tooltip

   I'm currently working on a database with some really complex calculations which are saved then in a table. Putting these formula in the MSDescription is a pain as it cannot be shown correctly in the appearing tooltip text.
   A nice Feature would be that I'm able to add a Hyperlink in the MSDescription which is pointing to the document in our SharePoint Server (or Wiki or whereever...).
   Or - if this is not working, would it be possible to define a Special RedGate Attribute/Property (e.g. MSDescriptionRedGate) below the MSDescription which is containing a hyperllink and this is then shown under the Standard tooltip?
   It would really help to simplify the documentation and I guess it could be also useful for the SQLDoc

   I'm currently working on a database with some really complex calculations which are saved then in a table. Putting these formula in the MSDescription is a pain as it cannot be shown correctly in the appearing tooltip text.
   A nice Feature would be that I'm able to add a Hyperlink in the MSDescription which is pointing to the document in our SharePoint Server (or Wiki or whereever...).
   Or - if this is not working, would it be possible to define a Special RedGate Attribute/Property (e.g. MSDescriptionRedGate) below the MSDescription which is containing a hyperllink and this… more

   4 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  ·  Intellisense  ·  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

   Submit Rating

6. Change quote completion behavior within Openquery or dynamic SQL strings

   I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
   So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.

   To illustrate the problem and my proposed solution:
   I am starting a statement like this:
   SELECT HOUSEKEY
   ,ESTIMATEDHOUSEHOLDINCOME
   ,SITEID
   FROM OPENQUERY(unica, '
   Select HOUSEKEY, ESTIMATEDHOUSEHOLDINCOME, SITEID
   from cm.householddemographics hd
   where SITEID in(

   At this point I need to enter a list of values separated by quotes and commas. Because this inside a string, I need to enter a pair of single quotes for at the start and end of every value, but when I type the second single quote, it gives me two, so now I have three single quotes when I was trying to get two.

   Ideally, SQL Prompt would see that I was inside string at this point and either turn off the completion so that when I type two single quotes , I get only two single quoutes, or even better it would always give me a pair of single quotes when I type one (though this could be a problem too, if not handled well).

   Hope that explanation makes sense.

   I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
   So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.

   To illustrate the problem and my proposed… more

   4 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  ·  Intellisense  ·  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

   Submit Rating

7. Align column aliases, but only up to a configurable MAX point

   The alias alignment is a nice feature that improves the readability of the formatted SQL. Still, it sometimes gets lost too far to the right when the selected column values include things like SQL functions and column names. In those cases, the alignment of the column aliases can require scrolling to the right to see them with a great amount of whitespace between the column name and the aliases and they thus become a detriment to the readability of the SQL.

   It would be great if we could configure a max number of spaces to align the aliases before which they just ignore any columns that are OVER that max and align as if those wide columns didn't exist.

   I'd still like them to align in that case, just skip the really wide columns that otherwise make the alias alignments unhelpful. The wide columns would just not have their aliases aligned at all with the other ones when this max is set and those columns exceed that max.

   The alias alignment is a nice feature that improves the readability of the formatted SQL. Still, it sometimes gets lost too far to the right when the selected column values include things like SQL functions and column names. In those cases, the alignment of the column aliases can require scrolling to the right to see them with a great amount of whitespace between the column name and the aliases and they thus become a detriment to the readability of the SQL.

   It would be great if we could configure a max number of spaces to align the aliases before which… more

   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

   Submit Rating

8. Intellisense for system stored procedure parameter values

   For system stored procedures, some parameters have a predefined set of possible values, e.g. msdb.dbo.sp_add_jobstep has the parameter @on_success_action.

   The MS documentation lists this predefined list of possible values:
   1 (Default) Quit with success
   2 Quit with failure
   3 Go to next step
   4 Go to step @on_success_step_id

   It would be great if Intellisense could suggest values for these sorts of parameters, saving a trip to Microsoft's website.

   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  ·  Intellisense  ·  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

   Submit Rating

9. CTE on new line with commas before items is adding an extra line

   When using the Lists > "Place commas before items" combined with the CTE >" Place CTE name on a new line" options, the subsequent CTEs are getting placed on new lines after the comma is already on a new line, resulting in:

   WITH
   myCte
   AS ( SELECT 1 a )
   ,
   mySecondCte
   ( Col1, Col2 )
   AS ( SELECT
   'Test' AS ThisIsAColumn
   , 'Test2' AS ThisIsAnotherColumn
   FROM Person.BusinessEntityContact )
   SELECT *
   FROM myCte

   I believe this combination of settings should be resulting in:

   WITH
   myCte
   AS ( SELECT 1 a )
   , mySecondCte
   ( Col1, Col2 )
   AS ( SELECT
   'Test' AS ThisIsAColumn
   , 'Test2' AS ThisIsAnotherColumn
   FROM Person.BusinessEntityContact )
   SELECT *
   FROM myCte

   Please fix, or add/modify options to make this possible.

   When using the Lists > "Place commas before items" combined with the CTE >" Place CTE name on a new line" options, the subsequent CTEs are getting placed on new lines after the comma is already on a new line, resulting in:

   WITH
   myCte
   AS ( SELECT 1 a )
   ,
   mySecondCte
   ( Col1, Col2 )
   AS ( SELECT
   'Test' AS ThisIsAColumn
   , 'Test2' AS ThisIsAnotherColumn
   FROM Person.BusinessEntityContact )
   SELECT *
   FROM myCte

   I believe this combination of settings should be resulting in:

   WITH
   myCte
   AS ( SELECT 1 a )
   , mySecondCte
   ( Col1, Col2 )
   AS ( SELECT… more

   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

   Submit Rating

10. Formatting style for CASE statement: on a new line

    Add a feature for the formatting styles for CASE expression.

    Currently the formatting is so strange, it adds indents that don't make sense.
    It should have the possibility to add CASE on a completely new line.

    Please add :Start expression on a new line or something…

    •  

    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

    Submit Rating

11. Add system versioned table scripting

    Add system versioned table scripting

    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

    1 comment  ·  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

    Submit Rating

12. Formatting Styles should include Global Style parameters

    Global formatting options like "Insert Semicolons", "Add brackets to all identifiers" etc should be part of a formatting style, this way changing a formatting style can also quickly switch between these options.
    Currently even after changing a formatting style these options on the screenshot below had to be manually changed one by one, it's inefficient to say the least.

    •  

    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

    Submit Rating

13. AI

    AI suggestions.

    I'm not part of your AI program waiting list. However here what I suggest.

    Do not make the AI part of your program an only cloud-based solution. There are plenty of opensource code models free for commercial use that can be ran locally on a PC. These models can also run under CPU but will up the memory to enable this feature requirements for AI on client side only. It's too dangerous for Redgate to store this information on the cloud even with a solid EULA, and laws are subject to change. Please offload this burden back to the users.

    Things I should ask it to do and have it do it.

    Have it build a local vector db / learn the database based on SQL History.

    Do query rewriting.
    Example: Tell it don't use case( and use convert( or vise versa and it will rewrite the syntax.

    Describe a SQL function/SP and have it write that code.

    Have it analyzed Query execution plan and make suggestions to the SQL query to improve its performance, like suggesting indexes, or a rewrite of the query to improve performance.

    Document my query / or document my database.

    Explain a data problem and have it try to figure it out. Example:
    Q: On Order 123, why is that order being reported Cancelled.
    
    A: You have QueryOrders you have a case statement ISCancelled if the Cancelled date is not null it returned as Cancelled.
     
    Q; What job will execute this stored procedure?
    A: Job RunSalesOrder step 4 will call this stored procedure.

    Translate SQL lang to another SQL lang.

    AI suggestions.

    I'm not part of your AI program waiting list. However here what I suggest.

    Do not make the AI part of your program an only cloud-based solution. There are plenty of opensource code models free for commercial use that can be ran locally on a PC. These models can also run under CPU but will up the memory to enable this feature requirements for AI on client side only. It's too dangerous for Redgate to store this information on the cloud even with a solid EULA, and laws are subject to change. Please offload this burden back to… more

    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  ·  Platform Support  ·  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

    Submit Rating

14. Open SQL History on startup / keep SQL History docked

    I prefer opening SSMS with no tabs and use SQL History to navigate tab history. It would be great to have an option to open SQL History on startup and/or if SQL History is docked then redock SQL History on startup

    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  ·  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

    Submit Rating

15. Add a table alias as a prefix to selected column names

    I would love an option where, after adding an alias to a table, you can add it as a prefix to all columns coming from that particular table at once.

    Some keystroke like Ctrl + F2 would be nice.

    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

    Submit Rating

16. Copy as IN clause" on a resultset - put results all on one line

    With SQL Prompt, and selecting "Copy as IN clause" on a resultset, is it possible to format the result as all one line, like:

    IN (1,2,3,4,5,6)

    instead of what it does currently:

    IN (

    1,

    2,

    3,

    4,

    5,

    6) ?

    Having it all on one line makes a statement easier to read, when there are a lot of items in the list.

    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  ·  User interface  ·  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

    Submit Rating

17. Add Trim() to LTRIM(RTRIM()) toggle

    For those of us who have to move between current and older versions of SQL Server, provide a tool to toggle all TRIMS in a script to LTRIM(RTRIMS()) and vice versa to make it easier to adapt scripts when moving between server version.

    Thanks,
    Mad Character Trimmer

    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  ·  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

    Submit Rating

18. Export snippets to text file

    At times you do not always have the luxury to have SQL Prompt installed on all machines. Hence, it is extremely useful if snippets can be exported to a plain text file, so that at least one has the ability to retrieve the much needed sql scripts quickly via plain text files. It would be of great help if each snippet is exported to an individual text file that should be named like the snippet name.

    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  ·  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

    Submit Rating

19. Prompt Styles As Buttons

    I've created a few different style templates and named them accordingly, but when I want to add them as buttons to quickly change between styles, there is just a list of styles with no label so I don't know what any of them are.

    So I have to trawl through and add each of them as a menu button until the one I want appears, which is incredibly frustrating and time consuming! When its on the menu bar as a button, it has the appropriate name rather than just "style" so can this be added to the add button menu please?

    I've created a few different style templates and named them accordingly, but when I want to add them as buttons to quickly change between styles, there is just a list of styles with no label so I don't know what any of them are.

    So I have to trawl through and add each of them as a menu button until the one I want appears, which is incredibly frustrating and time consuming! When its on the menu bar as a button, it has the appropriate name rather than just "style" so can this be added to the add button menu… more

    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

    Submit Rating

20. Replace the option Remove square brackets with Toggle square brackets

    I usually enclose database and server names in square brackets.
    Instead of only removing the square brackets, you could change that option (keeping its keyboard shortcut) to toggle between adding and removing them.

    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  ·  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

    Submit Rating