695 results found

1. Prefixes in function parameters

   SQL Prompt is removing prefixes from column names used as parameters in function-calls. For example, if you use Cross Apply to a system function:
   SELECT *
   FROM sys.tables AS T
   CROSS APPLY sys.fnlistextendedproperty('blah','schema',schemaname(T.schemaid), 'table', T.name, null, null)
   It removes "T." from schemaid and name in the parameters list. This means I have to add them back in if the column names are ambiguous. I don't see a setting for this, and have Prompt set to add prefixes to columns in the other clauses. So it'll add "T." to a column in the Select clause, and remove it from the same column in the function parameters.

   SQL Prompt is removing prefixes from column names used as parameters in function-calls. For example, if you use Cross Apply to a system function:
   SELECT *
   FROM sys.tables AS T
   CROSS APPLY sys.fnlistextendedproperty('blah','schema',schemaname(T.schemaid), 'table', T.name, null, null)
   It removes "T." from schemaid and name in the parameters list. This means I have to add them back in if the column names are ambiguous. I don't see a setting for this, and have Prompt set to add prefixes to columns in the other clauses. So it'll add "T." to a column in the Select clause, and remove… 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

   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

   Submit Rating

2. Apply casing formatting as I type, but without the suggestions.

   Currently, SQL Prompt either allows you to apply casing all at once with the Apply Casing Options, or it does it as you type if Enable Suggestions is turned on.

   Please add a feature so that I can have casing applied as I type, but without the suggestions.

   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

3. Allow importing of .settings file, and setting Code formatting/snippets folders and default formatting style to be done via Command line

   I would like to be able to better automate our onboarding process for new developers by helping ensure their snippets folder, formatting style folder and default formatting style are correctly setup. Additionally we would like to be able to automatically import settings from UNC/source control for them. This reduces the inevitability that something is missed when trying to follow a setup guide we have to additionally maintain. Thanks!

   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

   2 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

4. Use named parameters when encapsulating as new stored procedure

   It would be nice if the "Encapsulate as new stored procedure" logic used named parameter style so I don't immediately get ST008 in my code which calls the new proc.

   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  ·  Encapsulate as new stored procedure  ·  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. 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

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

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

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

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

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

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

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

13. Fix bug that causes SQL Prompt to crash when RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml is locked

    SSMS will freeze up and become unusable whenever RedGateSQLPromptCommonUIOptionsUIOptions.xml is being used by another program. Users can no longer use SSMS when this occurs and need to restart their computer when this happens. This has been very disruptive for the development team as this occurs multiple times per week.

    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

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

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

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

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

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

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

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