663 results found

1. Cloud Backup of all SQL Prompt Settings

   Hi guys,

   SQL Prompt is great. What is less great is migrating from one computer to another (or rebuilding your machine / VM / whatever).

   It would be super useful if we could have a cloud backup of all SQL Prompt settings, styles, and snippets which can be associated with our licence account.

   When we do an install on a new machine, we'd then be given the option to restore settings from the cloud.

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Tab History - Closed tabs

   It would be nice to have an ability to use either CTRL + click and SHIFT + click combos or to have check boxes there in order to select multiple closed scripts for a removal from Tab History instead of repeatedly hitting Remove context menu choice. It should save developer's time. Check boxes would be even better implementation choice, because that way you can apply context menu choice to a selection of scripts. Yay!
   Thanks!

   5 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Tab history  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Option / Action to remove square brackets from types

   I prefer types without square brackets ( INT vs [INT], for example).

   If using square brackets for identifiers in the format options, there is no quick way to remove these.

   My work-around is -
   1. Apply Format Style option "Add/remove brackets + Remove Unnecessary brackets"
   2. Format the block of code
   3. Apply format Style option "Add/remove brackets + Add brackets to all identifiers"
   4. Format the block of code
   5. restore format Style option to original choice

   It would be nice to have a single action to do this, or to have a separate option in format styles to "Remove square brackets from types"

   I prefer types without square brackets ( INT vs [INT], for example).

   If using square brackets for identifiers in the format options, there is no quick way to remove these.

   My work-around is -
   1. Apply Format Style option "Add/remove brackets + Remove Unnecessary brackets"
   2. Format the block of code
   3. Apply format Style option "Add/remove brackets + Add brackets to all identifiers"
   4. Format the block of code
   5. restore format Style option to original choice

   It would be nice to have a single action to do this, or to have a separate option in format styles to… more

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Smart Rename should be smarter about changing schema &table name

   When renaming both the table and schema name, and a table already exists w/ the old table name but new schema name, Smart Rename errors because it does not detect this conflict and tries to first rename the table to the conflicting table name.
   
   e.g., renaming stage.dboTable1 to dbo_stage.Table1 (and stage.Table1 already exists):

   EXEC sp_rename N'[stage].[dboTable1]', N'Table1', N'OBJECT'
   GO
   IF @@ERROR <> 0 SET NOEXEC ON
   GO
   ALTER SCHEMA [dbo_stage] TRANSFER [stage].[Table1]
   GO
   IF @@ERROR <> 0 SET NOEXEC ON
   GO
   

   would work if script instead did this:

   ALTER SCHEMA [dbo_stage] TRANSFER [stage].[dboTable1]
   GO
   IF @@ERROR <> 0 SET NOEXEC ON
   GO
   EXEC sp_rename N'[dbo_stage].[dboTable1]', N'Table1', N'OBJECT'
   GO
   IF @@ERROR <> 0 SET NOEXEC ON
   GO
   

   Note: your editor control apparently interprets special characters as HTML

   When renaming both the table and schema name, and a table already exists w/ the old table name but new schema name, Smart Rename errors because it does not detect this conflict and tries to first rename the table to the conflicting table name.
   
   e.g., renaming stage.dboTable1 to dbo_stage.Table1 (and stage.Table1 already exists):

   EXEC sp_rename N'[stage].[dboTable1]', N'Table1', N'OBJECT'
   GO
   IF @@ERROR <> 0 SET NOEXEC ON
   GO
   ALTER SCHEMA [dbo_stage] TRANSFER [stage].[Table1]
   GO
   IF @@ERROR <> 0 SET NOEXEC ON
   GO
   

   would work if script instead did this:

   ALTER SCHEMA [dbo_stage] TRANSFER [stage].[dboTable1]
   GO
   IF @@ERROR <> 0 SET NOEXEC

   … more
   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Smart rename  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Replace all inline comments with block comments

   It would be really useful to be able to choose the default comment style as either inline -- or comment block /* */, and have that style be applied when executing an auto-format on the script.

   See https://www.erikdarlingdata.com/sql-server/please-use-block-quotes-for-code-comments-in-your-t-sql/ for more info

   18 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Option to Omit Formatting of Comments

   Option (such as a check box) to omit active style formatting of comment lines between /* and */. Similar to SQL Prompt formatting off/on without the added code lines.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. Finding tabs with the same code

   Hi, the possibility to sort/show tabs with the same code. Then you can delete history if you have more than one tab with the same code. This will make history smaller and faster.

   7 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Tab history  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Suggest casting to match data types in joins

   In a large query, it can be a hassle to check every join to make sure the data types match up exactly (for example, nvarchar(50) <-> varchar(100)). These differences can have huge impacts on query performance in some circumstances, or lead to confusing results if data types are converted in an unexpected way. A suggestion to call out boolean statements comparing mismatched data types could be extremely useful.

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Code Analysis  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Enable click-away from the window for the "Summarize Script" feature in SSMS

   It would be really nice if I could click away from the summarize script window and scroll around in my script, or maximize the window for use on another monitor, or dock the window next to my script

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Summarize script  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Save Query Results / Results History

    One option that would be really neat, is to have the option to save the results of a query so I can compare the two sets side by side without having to drop them into Excel. e.g. run a query, tag it for archive, then after a time run the query again. And I'd have two Results Tabs in the output window. Results and Results(0). If that could be extended to multiple results windows, it would give me a simple way to track changes over time. And lastly, if tagged, the results would restore with the tab.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. "Re-connect" right-click menu option in Tab History

    TH knows the instance and DB the tab was connected to. Often, SSMS/SQL Prompt forget upon SSMS shut-down and fire-up the next day, to reconnect. (Happened 2020-10-02, so a current problem on just 4 tabs, when I often have a dozen open).

    Select one or more from any of the lists ==> right-click ==> new option to "Reconnect to saved instance-DB", or "Connect all to an Instance" (Problem with that is the default to master means we likely have to visit every tab anyway - unless RG gives us a better version of the Connect dialog! Where it connects and gives a list of databases to choose from... Then we can connect all to a named instance and DB combo! Nirvana!)

    Minimally, the ability to reconnect to saved state on demand for even one tab would be better than the more time-consuming path we must follow in plain old SSMS. (Perhaps an option to "Keep TH Open after reconnect" would be helpful, because multiple reconnects is frequently the need.)

    Thanks for considering.

    TH knows the instance and DB the tab was connected to. Often, SSMS/SQL Prompt forget upon SSMS shut-down and fire-up the next day, to reconnect. (Happened 2020-10-02, so a current problem on just 4 tabs, when I often have a dozen open).

    Select one or more from any of the lists ==> right-click ==> new option to "Reconnect to saved instance-DB", or "Connect all to an Instance" (Problem with that is the default to master means we likely have to visit every tab anyway - unless RG gives us a better version of the Connect dialog! Where it connects and… more

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Find Invalid Objects not working in v10.4.2 (SSMS 18.5, 18.6)

    Find Invalid Objects not working in v10.4.2 (SSMS 18.5, 18.6)

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. syntax highlight double quoted column aliases

    SQL prompt doesn't offer a single quote column aliases (which is fine). The code analysis feature says :

    "If aliases are standard identifiers, they do not need delimiters. If they are not, then they should be delimited by double-quotes, not single-quotes."

    what would be good is if SQL prompt had an option within SSMS to highlight double quoted column aliases in another colour (purple perhaps) just to make code more readable... sometimes the sea of black is hard to read when you have long, complex case statements etc.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. materialise temp table (from SELECT INTO)

    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 [dbo].[exampletable]
    (
    [name] [sys].[sysname] NOT NULL,
    [object_id] [int] NOT NULL,
    [principal_id] [int] NULL,
    [schema_id] [int] NOT NULL,
    [parentobjectid] [int] NOT NULL,
    [type] [char] (2) COLLATE Latin1GeneralCIASKSWS NULL,
    [typedesc] [nvarchar] (60) COLLATE Latin1GeneralCIASKSWS NULL,
    [create_date] [datetime] NOT NULL,
    [modify_date] [datetime] NOT NULL,
    [ismsshipped] [bit] NOT NULL,
    [is_published] [bit] NOT NULL,
    [isschemapublished] [bit] NOT NULL
    ) ON [PRIMARY]
    GO

    /SQL Prompt then replaces the SELECT INTO with the following code/
    TRUNCATE TABLE dbo.example_table

    INSERT INTO dbo.exampletable (name, objectid, principalid, schemaid, parentobjectid, type, typedesc, createdate, modifydate, ismsshipped, ispublished, isschemapublished)
    SELECT TOP 10 *
    FROM sys.objects

    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… more

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Macro Recorder

    Create a plugin to record and replay keyboard commands like notepad++ or sublime.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. 'Copy as IN clause' orizzontally too

    hi, i'd like to have the function 'Copy as IN clause' not only when i select data vertically but orizzontally too

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Tab History Window Behaviour

    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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. Show only column names in intellisense while doing SELECT

    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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Add option to choose Single/Multi-line script for INSERT and EXECUTE statements

    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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Dark mode support

    Dark mode support across all red gate tools.

    9 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close