689 results found

1. sonarqube

   Have SonarQube plugin that will do code analysis using your rules rather than TSQL or PLSQL plugins

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

2. Automatic Alias from Table Name

   (5 previous votes)

   Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.

   eg.

   Customer = C
   mem_Membership = M

   cus_StateCustomer = SC

   aReallyLongTableName = RLTN

   view_CustomerMembership = CM

   https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1931235-automatic-alias-from-table-name

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

4. 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

5. 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

6. 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

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

8. 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

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. Close pop up windows when holding down the control key while editing sql in SSMS

    While editing code in SSMS, i often find I want to use control key navigation (ctrl - left arrow for example) to navigate to a different part of the text i'm editing, but a pop-up intellisense window has arrived and instead of moving to the start of the word i'm editing, its trying to make me choose things from its pop up. It would be nice if ctrl key navigation would auto close the intellisense window so I could continue moving around the text of my query instead of having to hit escape all the time to close the pop up.

    While editing code in SSMS, i often find I want to use control key navigation (ctrl - left arrow for example) to navigate to a different part of the text i'm editing, but a pop-up intellisense window has arrived and instead of moving to the start of the word i'm editing, its trying to make me choose things from its pop up. It would be nice if ctrl key navigation would auto close the intellisense window so I could continue moving around the text of my query instead of having to hit escape all the time to close the pop… 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  ·  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

12. SQL Prompt - More Granular Suggestion. WHERE AND / CASE AND

    SQL Prompt - More Granular Suggestion. WHERE AND / CASE AND

    Would you add a couple of settings that give users more granular control in formatting SQL Prompt, please?

    In the CASE section, please add a section on how to handle Case AND statements, if we want the AND on a new line or the same line, and where to Align the AND.

    Also, please add a checkbox to align any '=' signs, like CASE WHEN colA = 1 then 1 else. I'd like all = signs to line up when there are multiple WHEN statements.

    Also, Please add a new WHERE Section, like the CASE Section, where we can have granular WHERE settings, similar to other settings.

    One part of the WHERE section would be the same as the above request AND section for the CASE section. Please add a section so we can configure if we want the AND on a new line or the same line, and where to Align the AND.

    SQL Prompt - More Granular Suggestion. WHERE AND / CASE AND

    Would you add a couple of settings that give users more granular control in formatting SQL Prompt, please?

    In the CASE section, please add a section on how to handle Case AND statements, if we want the AND on a new line or the same line, and where to Align the AND.

    Also, please add a checkbox to align any '=' signs, like CASE WHEN colA = 1 then 1 else. I'd like all = signs to line up when there are multiple WHEN statements.

    Also, Please add a… 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

13. 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

14. 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

15. 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

16. 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

17. 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

18. 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

19. 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

20. 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