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

63 results found

  1. Extend the column toolstips with the nullable attribute, like this "ic.Attachment varchar(max) not null (Column)"

    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

    1 comment  ·  Intellisense  ·  Admin →
  2. Due to the length of some of the queries I write, I have to edit the file RedGateSqlPromptEngine_EngineOptions.xml manually. It would be nice to be able to edit the values for ParserLookBackDistance and ParserLookAheadDistance in the Options menu. I understand the drawbacks of making these values too large. If they were in the Options menu I could adjust them for a long query and then set them back for shorter queries.

    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 →
  3. After upgrading to SQL Prompt 6 (6.1), I notice reduced performance and I occasionally get "SQL Prompt cannot retrieve objects from <some database name>. (etc)", which reference a database that I do not use or am ever likely to use and IIRC have never used. It seems SQL Prompt is trying to cache objects for all databases on the connected server. That would be overkill, and only serves to slow it down and cause errors such as the one mentioned.

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

    This was likely due to the synonym support added in 6 which will try to offer suggestions by loading databases that the synonyms are referencing. In the latest build of Prompt this is optional (under Suggestions→Connections) and off by default.

  4. Add a flag to order suggestion columns name by column order (not alphabetically).

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

    The latest version of SQL Prompt 6.3 should show column suggestions by the table schema definition order.

  5. 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 →
  6. We use a separate schema (z_audit) to capture data changes from dbo tables as a complete audit trail. The tables in each schema are named the same. Every time I come to the suggestions list, I either take it as read that the top table listed is in the dbo schema, or must click that little arrow at bottom-left to "show schema", involving having to grab the mouse just to expose the schema when we're supposed to be efficiently keying; no mousing involved unless we need to use a different suggestions tab...

    An option that toggles this to OUR preference…

    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

  7. after typing select and adding table name the popup box that shows the table summary (column names and their types); if these rows(column names) be clickable, select columns could be filled from that list instead of typing.

    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

  8. SQL Prompt v9.0.2.3223 use of Code Analysis has stopped the tooltip for showing structural details.

    ie: statement like SELECT a,b,c FROM dbo.TableRequiringLock WITH (ROWLOCK, XLOCK) WHERE ID = @key

    will just show TABLE HINT used when hovering over table name as opposed to showing the structure.

    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

    completed  ·  FabiolaB responded

    Hi,

    I am pleased to inform you that your request has been taken into account. Please update to the latest version in order to use it!

    Regards,
    Fabiola

  9. When using snippet with version before 6 (5ish), I could just hit tab and it will give me the correct code. However, with version 6, sometimes (half of the time), the first choice is nothing. It will do nothing rather than giving me the code for that particular snippet. Please fix it. It's very frustrating.

    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

    completed  ·  Aaron Law responded

    Hi Jay, I think this was fixed a while back but if you’re still encountering any issues with it let us know.

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

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

    completed  ·  Aaron Law responded

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

  12. 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 →
  13. 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 →
  14. Hi!

    It would be nice to have an IntelliSense for the DBCC SHOW_STATISTICS command.

    When typing

    DBCC SHOWSTATISTICS('HashAggregation','WASys00000001_2A8B4280')

    it would be helpfull to get the option of "WITH DENSITY_VECTOR" for example.

    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  ·  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

  15. ALTER DATABASE <DB Name>
    MODIFY FILE (NAME = '', NEWNAME = '')

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

    Hi Lee,

    Thanks for letting us know about this. NEWNAME is now suggested in SQL Prompt 7.2 which you can download from our website or through Check for Updates in the SQL Prompt menu.

  16. I have never clicked on a suggestion that results in opening the Microsoft Help window on purpose.

    As an example, if I have a long "IsNull" that takes up multiple lines, a tip box will pop up blocking portions of the query, and no matter where I click, this will pop up and block different portions. Often I will accidentally click the box as I need the cursor to be where the box is, and it will cause the dev environment to become unresponsive while the "Help" window loads.

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

    Hi Danny,

    It’s already possible to disable these tooltips in SQL Prompt. If you open up the SQL Prompt options, on the first page it’s under “Show tooltips for: Parameters”.

    Thanks,
    Aaron.

  17. SQL XML is a great tool that gets very little support. When I am on an XML type variable...the intellisense isn't great....AT ALL. Doing something like:

    declare @xml XML;
    set @xml = '<Tests><Test><Id>1</Id></Test></Tests>';

    select @xml.value --This doesn't have intellisense. It will try to capitalize .value to .VALUE which isn't correct.

    So better SQL XML support would be 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

    completed  ·  Aaron Law responded

    Hi Mario,

    In your example “value” will be suggested and left as lowercase in the latest version of Prompt 6. If you’re still having problems even on the latest version please contact support as you may have hit a bug.

    Thanks,
    Aaron.

  18. When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.

    SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
    Then a becomes an "unresolved alias"

    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

  19. Currently if you type a query like this:

    select *
    from sys.objects o
    order by o.name d[CURSOR]

    the popup consists of dbcc, deallocate, declare, delete, deny, desc, disable trigger, drop, dump.

    While that is probably technically accurate, it would be much more helpful to make "desc" the first entry in the list, because it's what I'm typing 100% of the time.

    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 →
  20. I added the 'dot' option to insertion keys and now I am unable to type dots in an IP address for a linked server without it autocompleting some random address, which I then have to go back and correct.

    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

  • Don't see your idea?