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

669 results found

  1. I pick up LOTS of legacy code with SELECT INTO statements.

    sometimes they are into temp tables but also in physical tables.

    It would be great to be able to highlight the statement in the SQL and right-click and choose to automatically convert it into a TRUNCATE + INSERT INTO (whilst running the CREATE TABLE statement for me)

    for example:

    /This is the statement I start off with/
    SELECT TOP 10 *
    INTO dbo.example_table
    FROM sys.objects

    /SQL prompt pops up with dialog box to choose the table name and creates the table for me/
    CREATE TABLE…

    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)
  2. Create a plugin to record and replay keyboard commands like notepad++ or sublime.

    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)
  3. hi, i'd like to have the function 'Copy as IN clause' not only when i select data vertically but orizzontally too

    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)
  4. Can the tab history window, when maximized, be made to consider the maximum screen size when it's popped out?
    I have monitors that have different resolutions and if I pop it out on my smaller screen it doesn't fit and I loose the top of the screen with the search and tabs - but most annoyingly that also means I loose the window bar so can't control the size either!

    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)
  5. Its really annoying to see table names suggestions in the intellisense while typing SELECT statement. I feel its not the new feature but its the bug to be fixed.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Currently SQL Prompt inserts SQL full INSERT script or EXEC SP in multiline while it might be useful for INSERT statement, but most of the times I have to realign them into a single line. It would be good if we have the option to choose wheather to add statement in single line or multi line? and its more usefull if we have shortcut to switch the inserted statement between formats?

    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. Dark mode support across all red gate tools.

    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

    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 GROUP BY only for 'by all non-aggregated columns' in 99% of cases. I've created snippet for GROUP BY (gb) and then I pick this option from the intellisense menu. It would be nice to have possibility to have snippet that would add these 'all non-aggregated columns' automatically most probably by adding new variable.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. So… Copy as IN Clause. Love it, but let’s improve it. Let’s say we have the following output…

    ProductID ProductDesc
    1 SQL Prompt
    2 SQL Search
    3 SQL Compare

    If we use Copy as IN Clause on the ProductID column, we get:

    IN
    (
    1,
    2,
    3
    )

    Which super…. However those IDs mean nothing to me in 6 months time when I’m now having to modify my code. What would be awesome, is if I can select both ProductID and ProductDesc, then hit Copy as IN Clause, and get the following output:

    IN
    (
    1, -- SQL Prompt
    2,…

    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

    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)
  10. Add an option to filter what tabs are moved into history.

    • SSMS autogenerated queries are of no interest.
    • So are simple DML and EXEC[UTE] queries consisting of one statement.
    • Successful executed ALTER {PROC|VIEW} are of no interest.

    Optionally calculate a query complexity value or class to hide simple queries.

    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

    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. Add a configuration option to automatically delete tabs by age (last executed or tab closed).

    Or move them outside the normal tab history (archive them) to speed up the normal history loading and searching.

    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

    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)
  12. It is common to create functions and stored procedures that have parameters with the same name as fields. Sometimes the @ is mistakenly skipped when creating a WHERE condition and you end up with something like ID = ID instead of ID = @ID. I would like intellisense that warns me about this type of error.

    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)
  13. When I am composing a script in Multi-Script, I'd like to have the editing settings available. Include variable/column name completion, keyword formatting, indention, etc..

    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)
  14. Fix "Script as INSERT" functionality with dates.

    Currently when I use this great functionality all the datetime fields will get a form N'1900-01-01T00.00.00'.

    Unfortunately the Finnish SQL server settings does not recognise that and running this script gives an error "Msg 241, Level 16, State 1, Line 2
    Conversion failed when converting date and/or time from character string.". I have not been able to find a way to change that date format in SQL Prompt Options.

    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)
  15. I would like to see intellisense provide you a list of backup devices that are created when you use the backup database key words.

    Backup database [database names in drop down] to [ disk, file, Url, backup devices in dropdown]

    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)
  16. When writing SQL, I frequently will create a variable within the statement before I have Declared the variable. It would be great if SQL Prompt offered a UI option to autogenerate the variable declaration.

    For example, given the statement:
    SELECT * FROM dbo.Person WHERE Username = @Username
    I would like to use a shortcut key to auto generate and insert the declaration above the statement:
    DECLARE @Username VARCHAR(8);

    For simple fields, the data type can be pulled directly from the field metadata. For expressions, derive the data type as SQL would if possible, or move the cursor to the data…

    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. When Place Begin - End statements on new line is selected it doesn't appear to work as part of an If statement. This makes the begin and end difficult to find

    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

    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)
  18. 'Script object as alter' (F12) works in ALTER statements but not in CREATE OR ALTER statements like. It would be nice if it also worked for the latter.

    Example:
    'CREATE OR ALTER VIEW [MyView] AS SELECT 1 AS Col1;'
    If I right-click on [MyView] in the above code snippet and select 'Script object as ALTER' (or hit F12), I would expect SQL Prompt to script the object if it exists.
    Currently nothing happens.

    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)
  19. Please add Prompt features when connecting to a Snowflake database

    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)
  20. I would like to expand upon suggestions others have made regarding adding custom formatting and analyzers.
    I have recently been trying to implement SQL Prompt for our team, and I have struggles with a lack of customization, opinionated options that don’t reflect our needs, and some bugs.
    What would have solved this issue for me would have been the ability to add custom formatters and custom analyzers.

    Custom Formatters
    Since SQL Prompt gets the position of tokens from IAlignmentProvider.FinalAlignmentForToken I suggest that the API couple simply be plumbed into this method, if a plugin is attached it would call the…

    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)
  • Don't see your idea?