Skip to content

SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums or our support portal.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

277 results found

  1. A Create/Declare Table statement with a Primary Key gives a false positive BP014 in Code Analysis

    If you have a table declared like this:
    Declare @Test table
    (TheKey int Primary Key,
    SomeData varchar(10) Not Null)

    I am told that for "TheKey" "[NOT] NULL option is not specified in CREATE/DECLARE TABLE statement" defined. But, a Primary Key can never be null, so it is NOT NULL by nature.

    So, when performing Code Analysis and the parser sees "Primary Key", "Not Null" should be inferred also.

    2 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Code Analysis  ·  Admin →

  2. ST008

    I'd like to vote for adding ST008 (non-named parameter style used) to the issues which can be auto-fixed. Hopefully it would be fairly simple to implement.

    9 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Admin →
    completed  ·  Thomas Walsh responded

    Hi,

    We’ve released this autofix in SQL Prompt 9.5.13.11024. Please let us know what you think!

    Thanks,

    The Prompt Team

  3. Put single quote marks around highlighted text (including multiple lines)

    Very often i have copied a list of items i want to query in an IN() statement from the database, for example:

    abc
    def
    ghi
    jkl

    and I want to format it like this:

    'abc'
    'def'
    'ghi'
    'jkl'

    or better yet:

    'abc'

    , 'def'
    , 'ghi'
    , 'jkl'

    Being able to highlight, right click, and select an option do do this, would be incredibly helpful.

    2 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    completed  ·  3 comments  ·  Format SQL  ·  Admin →

  4. Duplicate Tab

    One of the common UI interaction features in browsers like Chrome and IE is Duplicate Tab feature.

    Ususally the reason you might want to do this, could be because you want to keep an UNALTERED TAB and do SOMETHING DIFFERENT with another page...

    In SSMS this could be a great feature. Example of use please (- I hear you ask)? You could be trying to change script and test the effect of that change vs the original!

    MUCH MUCH Further down the line, you could extend this feature, to highlight the differences between tabs, a bit similar to file compare…

    4 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  5. code analysis blocks object detail

    SQL Prompt v9.0.2.3223 use of Code Analysis has stopped the tooltip for showing structural details.

    ie: statement like SELECT a,b,c FROM dbo.TableRequiringLock WITH (ROWLOCK, XLOCK) WHERE ID = @key

    will just show TABLE HINT used when hovering over table name as opposed to showing the structure.

    2 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    2 comments  ·  Intellisense  ·  Admin →
    completed  ·  FabiolaB responded

    Hi,

    I am pleased to inform you that your request has been taken into account. Please update to the latest version in order to use it!

    Regards,
    Fabiola

  6. Add an analysis rule checking for semicolons as statement terminators.

    2 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Admin →

  7. Code Analysis config to flat file

    Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I know not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.

    Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway…

    7 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    3 comments  ·  Intellisense  ·  Admin →
    completed  ·  Alicja Leszczynska responded

    Hello,

    We added this feature recently (in SQL Prompt 9.1.0.4138).

    Now it is possible to save your settings file in a shared folder for the team to use or switch between different settings files. This is accessible via the Prompt menu : SQL Prompt > Manage Code Analysis Rules….

    Let me know if you find it helpful.

    Kind regards,
    Alicja

  8. SQL Formatter error

    When using OPENJSON with the WITH clause, the formatter does not recognize the WITH clause as valid SQL. This should format but throws an error:

    DECLARE @JSONString NVARCHAR(MAX) SET @JSONString = N'{"Vendors":[{"VendorNumber":200,"VendorName":"Vendor1"},{"VendorNumber":201,"Vendo2"},{"VendorNumber":202,"VendorName":"Vendor3"}]}'

    SELECT VendorNumber ,
    VendorName
    FROM OPENJSON(@JSONString, '$.Vendors')
    WITH (VendorNumber INT '$.VendorNumber', VendorName VARCHAR(50) '$.VendorName')

    2 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    1 comment  ·  Format SQL  ·  Admin →

  9. SQL Prompt > Format SQL Update for SQL Server 2016

    Any query where "AT TIME ZONE" is used (new feature in SS '16), the Format SQL throws and error.

    "SQL Prompt was unable to complete this operation. Problem areas have been highlighted"

    The highlighting start from "AT TIME ZONE..."

    Thank you

    14 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →

  10. Formatting of AT TIME ZONE

    In SQL Server 2016 it is now possible to calculate between timezones. Currently it gives me an error, when I want to format it. The syntax is also not allowed at the moment.

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →

  11. create or alter

    SQL server 2016 SP1 introduced the "CREATE OR ALTER" PROCEDURE/VIEW - syntax, which would be very nice to have support for.

    https://support.microsoft.com/en-us/kb/3190548

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

  12. OPTION

    Hi!

    Would be good to control the formatting of the OPTION clause.
    I personally prefer to have it on a new line

    SELECT
    *
    FROM
    Production.Product p
    LEFT JOIN
    Production.ProductSubcategory s
    ON
    p.ProductSubcategoryID = s.ProductSubcategoryID
    WHERE
    p.ProductSubcategoryID = 14 OPTION(QUERYTRACEON 8757);
    GO

    --should look like

    SELECT
    *
    FROM
    Production.Product p
    LEFT JOIN
    Production.ProductSubcategory s
    ON
    p.ProductSubcategoryID = s.ProductSubcategoryID
    WHERE
    p.ProductSubcategoryID = 14
    OPTION(QUERYTRACEON 8757);
    GO

    Thanks!

    4 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    2 comments  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 8 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

  13. Formatting of Valid Selected code when there is invalid code in the script

    I used to be able to format selected code, as long as it was valid. Now when I select code that is valid in a larger script that has invalid code it does not format the selected code at all. If the invalid code immediately precedes it it will suggest that there is an error in the first character of my selection when there is none, else it will just act like it did something but do nothing. This used to work and is a frustration now. This has been the case with both 7.3 betas and I believe at…

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Format SQL  ·  Admin →

  14. format is now deleting extra lines after the query

    Looks like version 7.3 of SQLPrompt removes all blank lines after the query that it formats. Please change this back or make it optional to delete blank lines at the bottom of the query.

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →

  15. DBCC SHOW_STATISTICS('...','...) WITH DENSITY_VECTOR

    Hi!

    It would be nice to have an IntelliSense for the DBCC SHOW_STATISTICS command.

    When typing

    DBCC SHOWSTATISTICS('HashAggregation','WASys00000001_2A8B4280')

    it would be helpfull to get the option of "WITH DENSITY_VECTOR" for example.

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

  16. deleting snippets with d

    It would be nice if pressing the "d" key did NOT delete a snippet in the Snippet Manager!

    It took me two key strokes to figure out why the program didn't went to the first snippet beginning with a "d" - and now I have to spend time figure out what I have been deleting!!

    Of course, being able to navigate the long list of snippets using only the keyboard would be nice too. But of less importance. Deleting stuff without warning is bad, though!

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    0 comments  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

  17. Apply Tab Colors on any schema-updating tabs too

    Currently Tab Colors applies only on the Query tabs. It's much better to
    apply on schema-updating tabs too. Tabs such as Table/View designer or even Red-Gate SQL Source Control tab :)

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    1 comment  ·  Tab coloring  ·  Admin →
    completed  ·  Aaron Law responded

    Thanks for your suggestion Reza!

    We have already implemented this in the latest version of SQL Prompt so if you upgrade then both the table and view designers should have their tabs colored in the same way as queries. If they’re not being colored after upgrading to SQL Prompt 7.2 then you may have hit a bug so please do let me know.

  18. Don't alias objects with reserved words

    CREATE TABLE dbo.GrumpyOld (col1 int)

    SQL Prompt will alias the table as GO, which causes problems because it's a batch separator.

    Thanks!

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    1 comment  ·  Qualify object names  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

  19. decimal

    Hi, It would be great, if you add precision and scale on numeric/decimal data types - column hint and table summary.

    3 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    2 comments  ·  Qualify object names  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

  20. Option to remove gutter menu

    Please provide a way to turn off the gutter icon. I do not use it but what DOES happen is that I constantly activate it when I'm selecting and moving around in my sql. It's annoying - extremely.

    1 vote

    We're glad you're here

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

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Admin →
    completed  ·  Aaron Law responded

    Hi Nick,

    This should already be possible in the latest version of SQL Prompt (7.2.4), you can right click on the icon in the gutter and select “Disable actions list”. Alternatively there’s a check box in the SQL Prompt options on the behavior page for “Show actions list for selected test” and unchecking this should also disable the feature. If you have any problems with it still appearing after you’ve disabled it just let me know.

    Thanks,
    Aaron.

2 4 5 … 13 14
  • Don't see your idea?