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

578 results found

  1. 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],
    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

    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)
  2. Bring back TAB History!!! In the meantime, in SQL History, show the query/tab on the preview right side pane while hovering over the query on the left side.

    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

    0 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)
  3. SQL History sorts files by modified date ASCENDING. Its needs to be DATE DESCENDING. Need options to sort by name or date, ASC or DESC. Like how TAB HISTORY used to.

    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

    0 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)
  4. As I click open on a query in SQL History it gets displayed in a new tab. However this tab has no active connection. To be able to run the query I have to connect the tab manually to the database.
    For me it would be much easier if opening the query from History would also open a connection to the database the query ran the last time.

    If there are specific reasons why this was not implemented it would still be nice, if there were an option available to automatically connect to the server.

    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

    0 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)
  5. It should be possible to rename queries that are found by the search. Especially this concerns "starred queries". Unfortunately, the list of found queries lacks the small 3-dot menu that is available in the unfiltered list. And there you can rename a query if it is not currently open.

    That had worked in the old tab history. And it was a very important tool for me to save my queries under meaningful names.

    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

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. The following gives the warning "ORDER BY clause with constants". In this statement, "1" is not a constant, but a reference to the 1st column.

    SELECT TOP (10) Field1, Field2 FROM MyTable ORDER BY 1 DESC

    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

    0 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)
  8. I use the Copy as IN clause a lot and think it is one of the most helpful functions in SQL Prompt.

    It would be even better if it could format the IN list according to the Style setting you have selected.

    This is how it is created when right clicking on the function
    ContractsId IN
    (
    234151,
    234321,
    239990,
    228809,
    240808,
    231809,
    240021,
    230876,
    231739,
    239555,
    240972
    )

    If I then use format SQL it changes it to the way I want it, without line brakes for each row but in relation to the other statement.

    It would be…

    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

    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)
  9. There is a bug in SQL Prompt . It doesn't restore connection after restart when using "Azure Active Directory - Integrated" authentication in SSMS 18+ or SSMS 19+.

    Tab is opened as disconnected.

    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

    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)
  10. Over the years my Tab/Sql History became huge, and it is working very slow. I am looking for a way to clean up.
    1. There is no way to select multiple lines to delete. Delete is available only for one row. For example, every ALTER PROCEDURE creates history. I don’t need it at all. I would like to find all of them and delete.
    2. There is no functionality to compress and reindex Sql History database.
    3. Ironically “Send Feedback” link on a bottom of screen leads to nowhere.

    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  ·  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)
  11. SQL history. Recently this has become more indepth with greater search and history detail available. However it has lost some features which I found to be invaluable and which now make SQL history less useful to me.

    Find Starred items doesn't work as well now. It uses the advanced search which does not actually show if items are starred. Please correct that.

    Also there is now no ability to sort items found (in either normal or search view) by name / date etc.

    Can these features be re-implemented please.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Add a Refactor/Reformat option to REMOVE NOLOCK HINTS - with the NOLOCK hint deprecated and the hint being ignored in SQL Server 2022 and beyond, it would be great if refactor option in SQL Prompt to quickly remove WITH (NOLOCK) or (NOLOCK) hints from the selected SQL. It will be useable for years when addressing older SQL that utilized that hint. It would be helpful for the next decade at least to have a quick way to clean up the old SQL statements. If you can imagine how many times NOLOCK hints have been used in SQL Server over 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

    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)
  13. When opening a "New Query" window in Sql Server Management Studio (SSMS), SQL promt automatically load suggestions every time.
    If the connection with the server is strong, this tipically takes about 1-2 seconds.
    I am using a VPN that has a low bandwith and i have to wait 30-40 seconds every time i open such a window.
    Since i have the possibility to load the suggestions manually using CTRL + SHIFT + D,
    it would be great to have a setting that will prevent loading suggestion in every situation as described above.
    Just store the suggestions in the cache first…

    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

    0 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)
  14. There is no Smart Rename option for User Defined Table Types. This should be implemented.

    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

    0 comments  ·  Smart rename  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. using LocalDB, the database path names can be rather long, and in the Sql Prompt Invalid objects UI, there isn't a way to expand the database name, no pull handles or widening of the screen doesn't change the comboboxs dimensions which makes it hard to find the one I need without clicking through each one.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 'History for SQL Queryxxx' pane - there are too many versions. I don't need a version for every minor change. How about adding an option for how often to save versions?

    6 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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Recent queries section has date sections wrong. It is showing queries from last night as today. Maybe a time zone thing? It should use the machine's time zone.

    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

    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)
  18. In prior versions, SQL Prompt would connect open queries as SSMS was opening but it would not refresh suggestions (index associated database) until an open query tab was activated (selected).

    The current version (10.13.3.32087) still connects open queries but it also refreshes suggestions for all open queries as it is connecting them.

    This leads to a sluggish experience with both typing and an increased delay in the time it takes for SQL Prompt suggestions to display. I suspect it is due to the large amount of cached suggestions.

    I typically leave many query tabs open when working in SSMS so…

    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

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

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. We add certain standard columns to all tables (LastUpdatedDate for example). Would be great to be able to set a list of these columns in the Options so they can be excluded from list of suggested JOINS

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4 5 28 29
  • Don't see your idea?