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

(thinking…)

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

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

674 results found

  1. Dockable Summarize Script window that allows select/run of script blocks.

    Summarize script is sort-of useful as a way to see script blocks easily, but it will be BRILLIANT if it was a dockable (not modal) window that you very quickly select the script blocks in the editor.

    I often select parts of a script or subqueries to run - if Summarize Script automatically selected them for me it would be a huge productivity boost: 1-click selection + F5 = AWESOME!

    42 votes
    7 comments  ·  Summarize script  ·  Admin →
    How important is this to you?

  2. Choose to have ALTER instead of CREATE scripts

    When I hover over an object and get the pop-up script for that object (proc/view/function) I would like the ability to have the script default to ALTER instead of CREATE.

    99.9% of the time I manually have to edit the Create to be an Alter, this would save SO MUCH time.

    14 votes
    4 comments  ·  Script object as alter  ·  Admin →
    How important is this to you?

  3. Search Results in Grid Mode

    Find all occurrences of your search string in the results in datagrid mode. I know I should and could do this in SQL but sometime it is handle to find the customers name in a large set of rows.

    22 votes
    1 comment  ·  User interface  ·  Admin →
    How important is this to you?

  4. Add Excel Like Gripd To Results Options

    Add to the Results To options an Excel Like grid that presents the results i8n a grid but allows for Excel like functuionality without re-executing the query.

    I often am sending my data (via copy & paste) to Excel for aditional reserahc because the query takes a long time to run and I alrady have the core data I needd, I just need to fin tune it bu re-sorting or even re-aggregating the data differently.

    It wulod be a killer plus if Microsoft simply reaplced the existing SSMS Grid with a mini-version of Excel but since Thats not likely any…

    8 votes
    7 comments  ·  Admin →
    How important is this to you?

  5. convert SQL to a vbb (or c#) string statement

    in toad you can get it to convert a SQL statement into a VB or C# statement. i.e. if you have
    select * from atable
    where a = 'FREE'

    this would be converted to
    SQL = "select * from atable"
    sql =sql & "where a = 'FREE'"

    this is then pasted into the clipboard

    it can also do the reverse, have a chunk of VB code with a SQL statement, past it into the window, highlight it and it will try and convert it back to straight SQL (do not worry about variables added into the the vbcode, even toad…

    8 votes
    0 comments  ·  Admin →
    How important is this to you?

  6. Create CRUD

    Create a Select/Update/Insert/Delete procedure by rightclick a table.

    With option to select columns for each statement.

    34 votes
    5 comments  ·  Admin →
    How important is this to you?

  7. Convert code to dynamic Code

    Convert selected CODE or a complete stored procedure to Dynamic SQL Code.

    16 votes
    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

  8. Organize objects in SSMS with a folder stucture

    The reason I would like to see the folders is strictly for organizational purposes. I have so many procedures and tables in one database that I have to scroll through them all to find what I’m looking for. If I could organize by schema (or however I choose) and very quickly and jump back and forth between the different folders, that would help me out tremendously. The SQL filter function is so slow when going back and forth.

    What if I could organize sql instances that I'm connected to in one SSMS. Production and Development folders?? Just another thought.

    16 votes
    4 comments  ·  User interface  ·  Admin →
    How important is this to you?

  9. Template based formatting with different

    Template based formatting.
    Select your text and right click, format according to template... then select the appropriate template of your choice.

    8 votes
    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

  10. Generate Insert statements from resultsets, tables or database

    11 votes
    2 comments  ·  Admin →
    How important is this to you?

  11. Auto generated INSERT needs a column blacklist

    Add the ability to exclude columns from appearing in the auto-generated INSERT statements. I have to manually remove certain columns every time.

    9 votes
    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

  12. Please include support for Extended Events in SQL Prompt

    Extended Events is a great feature in SQL Server. Without support for this in SQL Prompt makes it incomplete.
    I know we have a GUI for it in SQL Server 2012. But it will quite sometime before everybody is on the latest version of SQL Server

    14 votes
    0 comments  ·  Intellisense  ·  Admin →
    How important is this to you?

  13. Change quote completion behavior within Openquery or dynamic SQL strings

    I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
    So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.

    To illustrate the problem and my proposed…

    4 votes
    0 comments  ·  Intellisense  ·  Admin →
    How important is this to you?

  14. Visual indication on open transaction

    Show a visual indication when open transactions exist in a query window (@@TRANCOUNT > 0)

    It could be changing the background color of the query window, and a number in the status bar showing the current transaction depth or something like that.

    34 votes
    3 comments  ·  User interface  ·  Admin →
    How important is this to you?

  15. Ability to Save invalid objects list instead of re-running entire database each time

    When you are working with a rather large database it would be nice to be able to save a list of invalid objects to come back rather than having to re-run through the entire database again.

    6 votes
    1 comment  ·  Find invalid objects  ·  Admin →
    How important is this to you?

  16. Add Colors to Database/Server Icons in Object Explorer

    Coloring the Tabs is very nice. I would love to have the database/server icons be colored (or at least a small colored dot on them) so I could see at a glance in Object Explorer what server the database is on.

    31 votes
    6 comments  ·  Tab coloring  ·  Admin →
    How important is this to you?

  17. Option to include the schema when generating an alias.

    I have tables that repeat in different schemas, for example Supplier.Location and Customer.Location. I'd really like auto-alias to include the schema when generating the alias. Supplier.Location should be SL and Customer.Location should be CL. Instead I end up with L and L2, which is not as clear.

    Ideally, I'd prefer the schema characters to be lowercase and the table to be uppercase. Using sL and cL would make my query even more readable.

    13 votes
    4 comments  ·  Qualify object names  ·  Admin →
    How important is this to you?

  18. Spell check on comments.

    Spell check on comments would be a nice addition to SQL Prompt. I know there can be misspellings within variables, table or any type of SQL object, but to at least have it in the comments would be nice.

    25 votes
    3 comments  ·  Intellisense  ·  Admin →
    How important is this to you?

  19. Align aliases, commas, datatypes and expressions at the next tab stop

    I align aliases, commas, datatypes and expressions at the first tab stop following the longest element in the list. See examples below:

    -- Tilde character used as space replacement to cope with HTML formatting
    -- 2-character tabs are assumed below
    -- In a fixed-space font, the commas, = signs, data types and AS keywords would all line up vertically
    DECLARE
    ~~@x~~~~~~~~~~~~~~INT~~~~~~~~~,
    ~~@var~~~~~~~~~~~~VARCHAR(4)~~,
    ~~@longer_varname~VARCHAR(10)~,
    ~~@z~~~~~~~~~~~~~~DATETIME~~~~;

    SELECT
    ~~~~@longer_varname~=~'x'~~~~~~~,
    ~~~~@var~~~~~~~~~~~~=~'1234'~~~~,
    ~~~~@z~~~~~~~~~~~~~~=~GETDATE()~;

    SELECT
    ~~~~T1.shortfield~~~~~~~~AS~ShortField~,
    ~~~~AO.really    longfield~~AS~LongField~~,
    ~~~~'x'~~~~~~~~~~~~~~~~~~~AS~XChar~~~~~~,
    ~~FROM~~~~~~~~dbo.table1~~~~~~AS~T1
    ~~~~LEFT~JOIN~dbo.another    one~AS~AO~ON~T1.keyval~=~AO.keyval;

    EXEC~@x~=~dbo.SomeProc
    ~~@Param1~=~'3'~~~~~~~~~~~,
    ~~@P2~~~~~=~'Longer~Text'~,
    ~~@P3~~~~~=~4~~~~~~~~~~~~~;

    27 votes
    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

  20. Right-click highlighted table and "Create Alias"

    When I find I want to define my own table Alias within SQL Prompt, I must go to the menu, click SQL Prompt, scan down for "Options", scan down for "Aliases", click "New" and then do something useful.

    Please obviate ALL THIS, by giving a right-click fastpath to "Add Alias" while in the script editor. If the table name happens to already exist, please position the list at it (just in case SQL Prompt had issues...)

    It is very laborious to have to navigate through all these clicks just to add an alias while in the code.

    17 votes
    6 comments  ·  Intellisense  ·  Admin →
    How important is this to you?
1 2 … 30 31 33
  • Don't see your idea?