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
  1. The way I work when creating complicated scripts is creating all the SELECT statements and then convert them to CTEs of my final query.
    It would be nice if you could convert SELECT into CTE

    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

    1 comment  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add a menu Item option to unformat a query. In other words take the query that is highlighted or every query in the script and convert them to be on a single line with only a single space between keywords, words, and operators.
    This would be very useful for having to copy SQL into a table or other some object that shouldn't have normal formatting in it.
    An option would be to double up all single quotes, so that the query can be placed between single quotes.

    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

    1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. Please add support for
    SQL Prompt Support for Azure Synapse (Azure SQL Data Warehouse)

    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

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
  4. The current parenthesis options I have set for an INSERT INTO (DML) statement, only appear to work for the list of columns, but NOT for the list of values in the VALUE clause. I'm unsure why this behaviour is different, but this inconsistency seems like a bug.

    I have provided a screenshot where you can clearly see the parentheses are not aligned correct in comparison with the INSERT statement.

    Ultimately I would like for the formatting to be overall consistent.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  5. SQL Prompt does not start a new line for the SELECT portion of a CTAS statement within Azure Synapse Analytics when there is a defined distribution or index using a WITH clause. Instead the SELECT statement is tabbed way over to the right.

    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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
  6. At the moment a user is warned before executing a potentially dangerous operation.
    However, junior devs might accidentally just press enter without thinking twice.
    Please add functionality to PROHIBIT execution besides WARNING (like SSMS Boost has) so that junior devs can't make mistakes at all.
    It would be fantastic if this would be possible.

    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
  7. It would be nice to search for multiple keywords in the Tab History. For example, I know I had a script to insert data from TableA to TableB, but I searching for TableA or TableB yields to much result (both are frequently use tables). Searching for "TableA, TableB" or "TableA*TableB" would be a good quality of life feature.

    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

    1 comment  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
  8. Using a shortcut to swap commented / uncommented lines in the sql script. This could be very helpful when we need to test (select / update) for the same source query.

    Please check the screenshots

    Thanks

    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  ·  Flag idea as inappropriate…  ·  Admin →
  9. Consider a table
    CREATE TABLE [dbo].[ItemGroups](
    [Group] [VARCHAR](25) NOT NULL,
    [Description] [VARCHAR](25) NOT NULL)

    SELECT Group from dbo.ItemGroups ->

    Incorrect syntax near the keyword 'Group'.

    Would be nice to get a warning when a column name is a reserved word. Square brackets make the syntax valid but unnecessary if a column is named more accurately, e.g. ItemGroupCode

    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  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
  10. In cases where there is SELECT DISTINCT or SELECT TOP(n) .. I would l like the option to format my table's columns to appear on the next line and indented 1 tab or set of spaces in from the SELECT and not necessarily aligned with DISTINCT or TOP in the line above.

    SELECT DISTINCT
    COLUMN1,
    COLUMN2
    FROM ...

    instead of

    SELECT DISTINCT
    Column1,
    Column2
    FROM ...

    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  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
  12. My idea is for the SQL Compare tool: when the warnings are displayed, it would be helpful to be able to copy text of these warnings to deal with them

    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  ·  Flag idea as inappropriate…  ·  Admin →
  13. All setup-options, except "Manage Code Analysis Rules..." seems to also be available from the "Options..." menu, which is nice ...

    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  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
  14. When a date or datetime field appears in a WHERE clause, include Suggestions of the following nature and dynamically substitute them upon selection with the nondeterministic or deterministic equivalents:

    (I couldn't get my table to format nicely here - please see the copy in the uploaded file.)

    (If it's currently 11am on Friday August 20 2021...)

    Suggestion Nondeterministic replacement Deterministic replacement

    now GETDATE() CAST('11am 20 August 2021' AS DATETIME)
    today CAST(GETDATE() AS DATE) CAST('20 August 2021' AS DATE)
    yesterday DATEADD(DAY, -1, CAST(GETDATE() AS DATE)) CAST('19 August 2021' AS DATE)
    tomorrow DATEADD(DAY, 1, CAST(GETDATE() AS DATE)) CAST('21 August 2021' AS DATE)…

    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  ·  Flag idea as inappropriate…  ·  Admin →
  15. Make the column picker the default tab when suggesting columns when the ursor is inside a select statement.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  16. In SQL Prompt, in the pop-up display for an object, allow drill down from an object reference in the popped-up display.

    In the new feature showing dependencies, implement drill down (from the "uses" section) and drill up (from the "used by" section)

    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  ·  Flag idea as inappropriate…  ·  Admin →
  17. Surround with, add to the list Select, Pivot, and I am sure there are more items like CTE

    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
  18. Sometimes my SSMS crashes. The Crash recovery of the program is not good enough. Would love to see "auto save" option that will save the open queries to history each time I'm idle for few moments. It would be much easier to recover than reproduce

    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  ·  Flag idea as inappropriate…  ·  Admin →
  19. Automatically insert a snippet as soon as you start a New Query in SSMS. I want all my developers to always start every script with a comment block with their username, date and a description of what the script is supposed to do. A shared snippet is already handy for this, but adding this could make it easier to build that habit for new team members.

    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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  20. You should fix the use of multiple versions of your name (Red Gate | Red-Gate | Redgate | redgate | red-gate) across all software and communications. See attached picture.

    We try to promote your products in our consulting company, but everyone uses a different name to refer to your company.

    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 24 25
  • Don't see your idea?