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

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

276 results found

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

    We’ll send you updates on this idea

    1 comment  ·  Intellisense  ·  Admin →
  2. Support SSMS 20

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  3. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
  5. 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)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
  6. 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)

    We’ll send you updates on this idea

    1 comment  ·  Tab history  ·  Admin →
  7. 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)

    We’ll send you updates on this idea

    3 comments  ·  Tab history  ·  Admin →
  8. 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)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
  9. 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)

    We’ll send you updates on this idea

    1 comment  ·  Intellisense  ·  Admin →
  10. 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)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Tab history  ·  Admin →
  11. 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)

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Admin →
  12. 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)

    We’ll send you updates on this idea

    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

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    1 comment  ·  Admin →
← Previous 1 3 4 5 13 14
  • Don't see your idea?