683 results found

1. VSCode integration.

   I've used SQL Prompt for 20 years. I would LOVE VSCode integration.

   93 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

   under review  ·  14 comments  ·  Platform Support  ·  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

   Submit Rating

2. Toggle SQL Prompt Suggestions

   I love the immediate suggestions when I need/want them, however when I do not want them, the suggestion box ends up blocking my screen more than it helps (Often blocking code I want to reference in a future query) and there is not a good way to make the suggestion box go away without clicking away from wherever it was suggesting.

   I know I can delay the popup and manually show suggestions with ctrl+space, but I would love to be able to manually hide them as well with ctrl+space as a simple toggle. It would greatly help me and other SQL developers in my department.

   I love the immediate suggestions when I need/want them, however when I do not want them, the suggestion box ends up blocking my screen more than it helps (Often blocking code I want to reference in a future query) and there is not a good way to make the suggestion box go away without clicking away from wherever it was suggesting.

   I know I can delay the popup and manually show suggestions with ctrl+space, but I would love to be able to manually hide them as well with ctrl+space as a simple toggle. It would greatly help me and other… 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

   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

   Submit Rating

3. Refactoring: Convert expression to cross apply

   Working with a query that contains the same expression multiple times, I often want to extract all instances of that expression into a CROSS APPLY for readability and ease of modification, e.g. converting something like this horribleness:

   select foo = case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end, count(*)
   from baz
   where case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end in ('a','b')
   group by case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end

   into something more manageable like this:

   select x.foo, count(*)
   from baz
   cross apply (
   values(case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end)
   ) x(foo)
   where x.foo in ('a','b')
   group by x.foo

   I would love to be able to highlight such an expression, right-click, and have a SQL Prompt option for "Convert expression to CROSS APPLY (replace all instances)", similar to Visual Studio's "Introduce Local" refactoring.

   Working with a query that contains the same expression multiple times, I often want to extract all instances of that expression into a CROSS APPLY for readability and ease of modification, e.g. converting something like this horribleness:

   select foo = case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end, count(*)
   from baz
   where case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end in ('a','b')
   group by case when bar < 100 then 'a' when bar > 200 then 'b' else 'c' end

   into something more manageable… 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  ·  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

   Submit Rating

4. SQL History - Recent query list filenames - increase number of characters displayed before truncation

   This is a minor inconvenience, but one with multiple potentially easy solutions. When using SQL History, I find that the "Recent queries" filenames become truncated very early due to the large font size and having only a single row of text used for displaying them. There is also a chunk of free space / padding to the right side that seems to be wasted (see orange arrow in my 2nd screenshot).

   Given the naming convention that I tend to use with my saved scripts ("date - internal ticket # - brief script description/purpose"), I often only see the date and ticket #, so there may be several queries in a row that appear to be named the same at first glance.

   If I horizontally drag to widen the Recent query pane to reveal more/all of my script files' names (as shown in my first screenshot), I then give up space on the query preview pane to the right. This results in a constant dragging of the Recent query list back and forth while navigating through the list and previewing the T-SQL.

   There are multiple potential ways I can think of to address this to varying extents:

   1. Reclaim the extra padding pointed out in my 2nd screenshot -- this at least gives room for perhaps one more word or two to be displayed.

   2. Add a setting to reduce the font size of "Recent queries" filenames (or just reduce it down to something like the size of the timestamp shown below it in gray to buy more space without having to add a whole new setting).

   3. Vertically expand the filename text area slightly and allow the filename to word wrap onto a second or even third line (or better yet, enable the user to vertically drag to resize as they desire, but this would probably require more dev time).

   [Edit: note that my attached screenshots' orders got uploaded in reverse order (so when I say "1st screenshot" above, it means the second/right-hand side one with a 40 KB size). Just adding for clarification.]

   Thanks!

   This is a minor inconvenience, but one with multiple potentially easy solutions. When using SQL History, I find that the "Recent queries" filenames become truncated very early due to the large font size and having only a single row of text used for displaying them. There is also a chunk of free space / padding to the right side that seems to be wasted (see orange arrow in my 2nd screenshot).

   Given the naming convention that I tend to use with my saved scripts ("date - internal ticket # - brief script description/purpose"), I often only see the date and… 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  ·  User interface  ·  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

   Submit Rating

5. Add Connection color to Object Explorer

   Dealing with multiple servers via the connection coloring is great, but looking at the object explorer while you are drilled down into things often has me scrolling to figure out what server I'm really looking at. Could we get a color bar in the object explorer that would simply have the color designated for the server.

   It would make it easier to tell what environment I'm looking at.

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

   Submit Rating

6. make update notification window resizable or autosize with Windows zoom

   I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)

   With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.

   However, for minor upgrades, I often skip the upgrade process since the bugs fixed likely do not pertain to my experiences. And that's where the inability to see the links at the bottom of the notification (remind me tomorrow, skip this update) is an issue for me. I can't see those links, and so I can't click "skip this upgrade", and so I get the notification every time I open SSMS. (I think the same may pertain to other tools such as Compare and Data Compare.) I can x-out the notification window, but I can't tell it to not reappear for this update.

   I would like the notification window to be resizable (or else auto scale with the Windows text zoom feature).

   I like to use the Windows zoom feature to make text bigger. (Not the dpi size feature, but rather the text size feature listed above the dpi setting.)

   With this increased, I cannot see the links in Red Gate update notification windows. I'll open SSMS and get a notification for prompt that I am running 1.0.7 and the latest version is 1.0.8. There is a details link that allows me to upgrade. I can also upgrade by downloading the latest version of the tools from the Red Gate web site.

   However, for minor upgrades, I often skip the upgrade process… 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  ·  User interface  ·  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

   Submit Rating

7. Show Code Window Even if Schema is Missing

   When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.

   However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.

   While it may be advantageous to have this rule enabled, it would also be beneficial to view the object code when the object's schema name is not present.

   When I scroll over an object *table, view, function, stored procedure), SQL Prompt typically displays a tooltip that describes what the object is (e.g. Table). I can click on the tooltip and see a script of the object.

   However, if I have not included the schema, then I do not get the tooltip, but rather a warning that "Schema name for table or view is not specified" and I am not able to view the object code without either disabling that alert or adding the schema name.

   While it may be advantageous to have this rule enabled, it would also… 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  ·  Intellisense  ·  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

   Submit Rating

8. Colorize vertical tabs

   Tab coloring doesnt work in vertical tabs mode

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

   Submit Rating

9. Add a “Save Results As” Excel option

   This is needed because I am required to run SSMS with elevated rights.

   My regular Windows login doesn't have access to my database servers, and my elevated account doesn't have access to my MS 365 office suite.

   Because of this, the "Open in Excel" feature is not useable.

   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

   Submit Rating

10. HoverOver Popup Incorrect

    Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.

    Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.

    In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.

    In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.

    Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt HoverOver popups.

    The SQL text shows the problem. Run the script then come in and hover over the OrderID and OrderItemID fields in the different places in the SELECTs.

    HoverOver1.png shows how it looks on the Inner most SELECT. Both are Int.
    HoverOver2.png shows how it looks on the Outer most SELECT. Microsoft is varchar and SQL Prompt is Int.

    Using SSMS 21.4.8 and SQL Prompt 11.0.6.17341.

    Using a derived select to retrieve data then derive select that to change the data types then a third derived select to present the data.

    In the inner most SELECT, the fields OrderID and OrderItemID are Integer in both the the Microsoft and SQL Prompt HoverOver popups.

    In the outer most SELECT, the OrderID and OrderItemID are Varchar in the Microsoft HoverOver popup but Integer in the SQL Prompt HoverOver popups.

    Also in the outer most SELECT, down in the ORDER BY, they show differently hovering over between the Microsoft and SQL prompt… 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  ·  Intellisense  ·  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

    Submit Rating

11. Go to variable definition

    I would like a feature that allows a user to right click on a variable name and allow for an option of Go To Declaration so it would scroll up to the place where the variable is declared. The hover option shows how it is defined, but not where it is defined which is also extremely helpful when troubleshooting and researching a script.

    6 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

    under review  ·  0 comments  ·  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

    Submit Rating

12. Alignment of nulls

    How can we get the following alignment with nulls? Please review the pre & post images attached

    •  

    •  

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

    Submit Rating

13. Keyword KEEP_CDC not recognized in RESTORE statement

    Add support for the KEEP_CDC keyword. Example:

    RESTORE DATABASE MyDB
    FROM  DISK = N'\\SOMEWHERE\MyDB_FULLBACKUP1.BAK'
    WITH FILE = 1,
    MOVE N'MyDB_DATA' TO N'M:\SQLData1\SQL_DATABASE\MyDB.MDF',
    MOVE N'MyDB_LOG' TO N'M:\SQLLogs1\SQL_DATABASE\MyDB_LOG.LDF',
    RECOVERY, REPLACE, STATS = 1, KEEP_CDC, NEW_BROKER, RESTRICTED_USER
    

    Currently the formatting process errors out.

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

    Submit Rating

14. Add IntelliSense/AutoComplete Support for ALTER ROLE...ADD/DROP MEMBER Statement

    I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.

    It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember and spdroprolemember sprocs) are deprecated now and MS recommends the use of ALTER ROLE instead.

    Thank you in advance for your consideration.

    I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.

    It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember… 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  ·  Intellisense  ·  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

    Submit Rating

15. Option to hide "find invalid object" menu

    This feature crash SQL Server because our procedures multi-databases, encrypted and so-one and not a needed feature. But the menu is misclicked lot of times and crash SQL Server.
    Could you please, add an option to hide "find invalid object" menu

    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  ·  Find invalid objects  ·  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

    Submit Rating

16. Automate replacing variables with literals for troubleshooting stored procedures

    Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.

    It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the edited code.

    Quite often when troubleshooting a stored procedure, it is helpful to step through it and run each statement individually. In stored procedures that take parameters, though, you need to manually swap out the variable name for a test value in each statement, or put variable declarations and sets in front of each statement.

    It would be convenient if SQL Prompt could automate this process. It could check for parameters, prompt the user to provide values for them, then do the variable-to-literal substitution throughout the code. It could then provide an easy way to reverse the change to support committing the… 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  ·  Code Analysis  ·  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

    Submit Rating

17. SQL Search endpoint for Fabric

    Make SQL Search work with Fabric

    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  ·  Find unused variables  ·  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

    Submit Rating

18. Add or detect missing 'N' on inline string literals containing Unicode characters

    This is an extension of:
    https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/6779217-add-n-to-unicode-type-literal-strings

    Except I would like to improve this feature so that it is not limited to just variable declarations, but also for inline string literals.

    For example, if an inline string literal contains a unicode character, it should have the N prefix. If anything it should probably be a Code Analysis rule rather than formatting because this change can absolutely impact code behavior. So I think it's better suited to be an analysis rule.

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

    Submit Rating

19. exclude suggestions

    SQL Prompt includes a feature to exclude specific databases – in this case, the master database – we would expect this functionality to reliably prevent any interaction with the excluded databases during code suggestions or IntelliSense operations. The current behavior suggests that the exclusion option may not be functioning as intended.

    We expect that when an exclusion is defined, no connection attempt should be made to the excluded database. This would allow all other user databases to be loaded, even if with limited functionality.

    pls. check http://productsupport.red-gate.com/hc/requests/333558

    • 

    •  

    •  

    •  

    •  

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

    Submit Rating

20. Set preferences for automatically numbering new queries

    New queries, as users know, have an automatic naming and numbering system:
    SQLQuery1.sql, SQLQuery2.sql, SQLQuery3.sql, etc.

    It would be helpful sometimes if the queries could have leading zeros or maybe even a different lead-in like the name of the solution. For example, SQLSolutionABC might have the default tab names:

    SQLSolutionABC001.sql, SQLSolutionABC002.sql, SQLSolutionABC003.sql, 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  ·  User interface  ·  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

    Submit Rating