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

275 results found

  1. Keyboard shortcut for Snippet Manager

    It would be great to have a Keyboard Shortcut to launch the Snippet Manager. I currently have it as a toolbar button, but a shortcut would be good so I don't have to leave the Keyboard..

    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  ·  Intellisense  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  2. support for create external table as (CETAS)

    SQL Prompt is throwing an error when the syntax for CETAS is included.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas

    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 →
    How important is this to you?

    We're glad you're here

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

  3. support for new SQL Function DATE_BUCKET

    Please add support for new SQL Functions such as DATE_BUCKET
    https://learn.microsoft.com/en-us/sql/t-sql/functions/date-bucket-transact-sql?view=sql-server-ver16

    Currently it get quoted which is quite inconvenient. 

    declare @date datetime2 = '2020-04-30 21:21:21'
Select 'Week',  DATE_BUCKET(WEEK, 1, @date)
Union All
Select 'Day',  DATE_BUCKET(DAY, 1, @date)
Union All
Select 'Hour',  DATE_BUCKET(HOUR, 1, @date)
Union All
Select 'Minutes',  DATE_BUCKET(MINUTE, 1, @date)
Union All
Select 'Seconds',  DATE_BUCKET(SECOND, 1, @date);

    becomes

    DECLARE @date DATETIME2 = '2020-04-30 21:21:21';
SELECT   'Week', [DATE_BUCKET] ( [WEEK], 1, @date )
UNION ALL
SELECT   'Day', [DATE_BUCKET] ( [DAY], 1, @date )
UNION ALL
SELECT   'Hour', [DATE_BUCKET] ( [HOUR], 1, @date )
UNION ALL
SELECT   'Minutes', [DATE_BUCKET] ( [MINUTE],
    …
    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  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  4. Add formatting for CREATE EXTERNAL TABLE syntax

    CREATE EXTERNAL TABLE and CREATE EXTERNAL DATA SOURCE syntax is not formatted nicely by SQL Prompt, it just puts the statements on one line.

    I've been told the developers are not going to take this on!!!!

    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  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  5. SQL History initial cursor location

    When opening SQL History, it should default the cursor to the search input box instead of requiring an additional click to start a search. Since 90% of the time I'm going to input a search, it makes sense to put it there.

    This has no downside as, currently, the cursor doesn't by default go to anything.

    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  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  6. SQL History keyboard shortcut

    Just like Tab History has, SQL History should have a keyboard shortcut to open the window.

    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

    3 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  7. Recognize the DateTrunc function in T-SQL.

    The formatter is not recognizing the newish DateTrunc function in T-SQL, so formatting and intellisense do not work on SQL statements that include DateTrunc.

    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  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  8. When generating Insert code use defaults

    If you create a table with a BIT column not nullable with a default value, and then you type insert, the autocomplete gives you null for the bit column. Example below. (I haven't looked at what happens with other data types/defaults.)

    CREATE TABLE dbo.MyTable
    (
    Flag BIT NOT NULL CONSTRAINT DFMyTableFlag DEFAULT (0)
    )
    GO

    INSERT INTO dbo.MyTable
    (
    Flag
    )
    VALUES
    (NULL -- Flag - bit
    )

    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  ·  Intellisense  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  9. Be able to open a tab from tab history even when no other ssms tabs are open

    Currently when you attempt to open a tab from tab history and there are no other tabs currently loaded in SSMS the attempt from tab history freezes SSMS and causes it to crash. A feature that made that not happen would be good.

    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  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  10. Integration with Visual Studio 2017

    I'm using SQL Prompt with both SSMS (v18.5) and Visual Studio 2017 (version 15.9.23). Everything was working fine in both environments but since updating SQL Prompt to version 10.2.1.15260 I've completely lost all SQL Prompt integration in Visual Studio.

    I'm aware that Visual Studio 2017 includes SQL Prompt Core but I'd always shied away from using that because I couldn't see any evidence that it would keep itself updated. When I'm building a new solution that requires a database component I find it useful to be able to add a Database project so that I can source-control everything in the…

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  11. Allow SQL Prompt to work with no access to master.sys.sysservers table

    SQL Prompt fails when the user does not have access to the sysservers table in master database. It is becoming increasingly common for DBA groups to revoke/deny this permission to developers. For our org it was the result of an independent audit/penetration test. There are other procedures etc the provide the same information without this specific access. I have provided examples and troubleshooting steps to Redgate support but with no resolution. Their suggestion was to post a request here.

    5 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  Thomas Walsh responded

    Hi,

    We released this feature in SQL Prompt 10.3.3. The only reason SQL Prompt ever needed to query the master database was to get the list of linked servers. If you upgrade to that version and ensure the “load suggestions for linked servers” option is disabled, SQL Prompt should load suggestions correctly.

    Thanks,

    Tom
    SQL Prompt Team

  12. Turn off notifications such as "Slow cached time detected".

    Have the ability to turn off notifications such as "Slow cached time detected". I see it every time I connect to a database - and I work with every element in the db's so I want it all to be cached. But I do not want to see this notification every single time.

    34 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

    16 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  13. MFA (multi factor) Support for Azure SQL Databases

    Support Azure multi factor authentication for accessing Azure SQL Databases.

    69 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

    19 comments  ·  Platform Support  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  14. Autofix with shortcut

    A shortcut to implement the autofix changes.
    Would be nice if it wasn't necessary to use the mouse when applying autofixes.

    It is almost there; you can press ctrl and get the error window and even just press enter then, to apply the fix. But the window stays and there is no reason to actually open the window, the fix could/should just be applied

    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  ·  Code Analysis  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  15. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    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  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  16. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    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  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  17. transparency

    Hi, new feature with transparency on Ctrl in SQL Prompt 9.4.10 is extremely annoying, I'm using only Ctrl+Space to show intellisense. Please provide us option to disable this feature, or change key to Alt or Ctrl+something, this is really horrible, please fix it asap. I've to uninstall tool for now.

    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  ·  Intellisense  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  AdminAdrian B (n/a, Redgate) responded

    Many thanks for your useful feedback on this issue.

    We’ve done some further work on this feature that should hopefully address your issues. This has just been released in SQL Prompt v9.4.11 (available from https://www.red-gate.com/products/sql-development/sql-prompt/).

    The popups will now only go transparent after holding the Ctrl key for a short period instead of immediately. This should mitigate the issue somewhat. In addition, there is a new option (in Suggestions → Behavior → Make popups transparent when the Ctrl key is held down) to turn the feature off if it is not wanted.

    Kind regards,

    The Prompt Team

  18. Disable auto update check on startup

    It would be nice if we can turn off the auto update check for a new version on start-up. This check is happening in the Visual Studio database project and in SSMS. I'd like to disable it. Thanks!

    36 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

    32 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  AdminTim Dalton (Product Manager, Redgate) responded

    In Prompt 10.0.11 we added a new option to the help menu called ‘update notification frequency’. This will allow you to reduce the frequency of updates all the way down to major versions only (one update a year).

  19. Bring back the Ctrl+B, Ctrl+B hotkey for removing square brackets please. I used it all the time and the last update seems to have removed

    I updated to SQL Prompt 9.4.7.7595 yesterday and since then I no longer have the hot key. It is still on the menu, but no hotkey. I used that feature hourly. If you wish, allow users to define the hotkey combinations or disable them, but simply removing them is inconvenient.

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

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

  20. 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
← Previous 1 3 4 5 … 13 14
  • Don't see your idea?