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

274 results found

  1. Here’s what’s happening: I am typing along and I hit space instead of tab which does not complete the fill in (I actually like this so I don’t want to add the space as a completion key). I would like a mappable key combination to get the prompt to re-open.

    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  ·  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)
    completed  ·  Aaron Law responded

    Ctrl+Space will bring back the suggestion box, but also the latest build of Prompt will bring it back if you just continue typing after you left off (if you didn’t purposely hide it with esc)

  2. Hi!

    Please consider this statement

    update t1
    set t1.value = t2.value
    from Table1 t1
    join Table2 t2
    on t1.ID = t2.ID

    When you have the cursor in the set-block of the statement, SqlPrompt doesn't know what 't1' means and which columns t1 has.

    30 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)
  3. When loading management studio it would be great if tab magic could get a list of the required connections before the tabs are loaded and test each one silently to see if a connection would be possible (i.e. host is available) If the host is available then prompt for login once per host, if host is not available simply load the tab as not connected.

    This would make the experience much nicer as at the moment if I had say 15 tabs open to a host that I am no able to connect to (I work on multiple sites) I…

    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

    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)
    completed  ·  Aaron Law responded

    SQL Prompt 6.1.0.71 will try a silent background connection before getting SSMS to connect the query.

  4. Allow the option to NOT indent else if statements. Each of the ELSE IF statements gets further indented and for large SQL it becomes indented off the screen. I can imagine this pattern could apply else where but for this specific use case our STPs that have this condition i simply can't format the sql because it requires me to horizontally scroll. Allowing me to disable indenting ELSE IF statements would solve this problem instantly.

    21 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

    2 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)
  5. When I click on 'Recently Closed Tabs' I get a window showing 20-ish closed tabs and their contents. If I resize the window, it fills with more, so I know that further history can be accessed.

    I understand that the best way to find 'old' queries is to type in the search box to try and filter the history, but sometimes (and it is only sometimes) I just want to scroll down the history and see all the closed tabs. Not saying all the history should be loaded - I guess that would take a lot of memory, but it…

    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  ·  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)
  6. Formatting a section (selected code block) with CTRL+K, CTRL+Y). This would allow me to highlight a section of a proc and format it to my liking and leave the (abomination) of the proc body untouched.

    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

    completed  ·  3 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. Currently, no matter what settings are applied, table names are always placed on a new line, for example:

    SELECT
    ID,
    Thing

    FROM
    TableName

    JOIN
    OtherTableName
    ON blah=moo

    WHERE
    something <> something else

    My personal preference is for:

    SELECT
    ID,
    Thing

    FROM TableName

    JOIN OtherTableName
    ON blah=moo

    WHERE something <> something else

    Please can we have an option to achieve table names on the same line as their action (FROM / JOIN)

    13 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

    11 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)
  8. In the T-SQL editor it'd be really good if you could rename variables easily. In VS, if you use Resharper clicking on a variable and hitting F2 allows you to rename that variable and all occurrences of it easily. It even searches strings and comments and offers these as an option

    22 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)
  9. For any attempt to use Intellisense within a RAISERROR() there is no prompting - list says "No suggestions".

    Sample:
    RAISERROR('Not at 12hrs UTC - time is %s',0,1,@<<Nothing-here>>) WITH NOWAIT

    Also reported as a defect on the SQL Prompt Forum

    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)
    completed  ·  Aaron Law responded

    The latest version of Prompt should give you suggestions within a RAISEERROR

  10. Include an option when reformatting SQL to automatically add semicolons at the end of each statement if they are missing.
    While in most cases SQL Server 2005 and 2008 don't require this, the 2008 docs mention that a future version might.
    and it may also be helpful if trying to move code from SQL Server 200x to a dialect which does require them.

    85 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

    9 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)
  11. Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows. This would be a very helpful feature to keep data types consistent throughout a database if one doesn't want to set up a user data type for each and every column that stores data types with additional parameters like, for instance, the scale and precision.

    11 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)
    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. SQL Prompt does not recognize the new ROWS | RANGE keyword additions to the OVER clause in SQL Server 2012

    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)
  13. I would like an option to align the type declarations, for example when declaring the columns in a table variable I currently get:
    DECLARE @MyExample TABLE
    (
    MyCol1 INT ,
    MyOtherCol VARCHAR(10)
    )

    Which I would quite like to see laid out as:
    DECLARE @MyExample TABLE
    (
    MyCol1 INT ,
    MyOtherCol VARCHAR(10)
    )

    The same is true for all other places where I'm declaring, so the parameters for a procedure for example

    12 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

    4 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)
  14. Don't expand wildcard occurrences within EXISTS clause.
    WHERE EXISTS(SELECT * FROM tab1)
    should not expand to
    WHERE EXISTS(SELECT col1, col2, col3 FROM tab1)

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Need Intellisense for the spatial functions and geography/geometry data types, especially since they are case sensitive, and annoyingly a mixture of upper and lowercase.

    7 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  ·  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)
  16. When object names appear in the candidate window for an autocomplete, the schemas are not shown by default. Clicking on the the arrow in the bottom left of the window will show them, but this setting is not remembered so you have to do it each time. Also there's no keyboard shortcut that I can find to do this. Add the ability to set this popup to show the schema names by default.

    7 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. In SSMS when accessing a table that is not in the current database (using the three part convention) then no intellisense is coming up for the fields (such as in the where clause)

    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)
    completed  ·  Thomas Walsh responded

    SQL Prompt now supports suggestions from other databases when using the three part convention.

    Kind Regards,

    The Prompt Team

  18. When disabling SQL prompt (or when a trial ends) the default SSMS intellisense is not getting back to work.
    This is especially important since there are a lot areas that the native SSMS intellisense is much better than SQL prompt (I will try to post all of them), so one might try to take advantage of it.

    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  ·  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)
  19. I would like the ability to get Format SQL to handle my JOIN formatting - I like to have my JOINs look like this:

    SELECT
    (columns)
    FROM
    sys.tables t
    INNER JOIN
    sys.indexes i ON t.OBJECTID = i.objectid

    That is: I want to have my tables being joined lined up with the (intended) table in the FROM clause, and I like to have my JOIN condition on the same line as the joined table.

    Right now, I cannot seem to get this to work - the table name and join condition are always stuck onto the same line as…

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  20. Please see forum thread http://www.red-gate.com/MessageBoard/viewtopic.php?t=14749

    I ran into what I would consider a serious issue with the Script Object as ALTER feature. A few hours earlier I had changed a stored procedure script and executed the Alter script so the change was now "active".

    A few hours later, within the same SSMS application (but different query window) I used the right-click Script Object option as a shortcut so I didn't have to scroll through a very long list in Object Explorer... Unfortunately it scripted the OLD version of the procedure and not the one changed hours earlier.

    Now, I know…

    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)
    completed  ·  Paul Stephenson responded

    As of SQL Prompt 5.2.8, Script as ALTER will always fetch the script directly from the database.

  • Don't see your idea?