- or
3 results found
-
Outlining
Would be great to be able to add user specific outlining, so that you could add + & - where ever you choose in a sql script to collapse down certain parts. The CRM system that I support has a create contact table import with 200 columns which is regularly used and this functionality would be great when having to resort to using this import etc...
6 votes -
Outline for scripts
It would be very helpful if there was an outline for the script being edited. Say, a script has many "CREATE PROC"s. We could have a tree or a list or a drop-down, to view a list of CREATE PROCs and click to scroll to the section.
If a tree style is selected, this could be expanded into seconds inside each PROCs.
3 votes -
code folding
Enabled Intellisense conflicts with SQL Prompt and needs to be disabled. This also disables Code Folding feature (Outline Statements) of SSMS, which is very useful for large coding projects.
It would be helpful if SQL Prompt were to offer the similar feature.8 votes
689 results found
-
format grouping sets
format grouping sets in the same way as other lists.
currently they are made into one long line regardless of the wrapping setting.1 vote -
Warn if comparing column to itself in WHERE clause
I would love a warning to prevent the classical mistake of comparing a column with itself instead of with another column in a WHERE clause.
An example is the following, where I would like a warning where one has "qlpd.interimdisbursementid = qlpd.interimdisbursementid" as it should be qlpd.interimdisbursementid = di.interimdisbursementid instead:
SELECT *
FROM dbo.datinterimdisbursement AS di
INNER JOIN dbo.qlirologPayoutServicedata qlpd
ON qlpd.interimdisbursementid = qlpd.interimdisbursementid;1 vote -
Copy (just) 1 or more headers from result
I would like the ability to select 1 or more values in a result and have the (right-click?) option to select header(s). I then have the header, or headers separated with commas in my clipboard.
1 vote -
Search for column in result
I would LOVE! the ability to have a search window with my results from a query, where I type in any part of a column name and it lists all columns containing value I typed in.
By default one is positioned on the applicable column in the result (scrolling if necessary in wider result set), but if one clicks on any column matching value then it positions one on that column in the result.1 vote -
FREEZES SSMS - Add what tool (name) caused the error to the title of an error window
The error popup comes out of nowhere when navigating SSMS tree nodes, notably when selecting a specific database name. I expected it came from SQL Prompt, but there was nothing being logged even when verbose option has been enabled.
The support helped clarify it "probably" came from SQL Source Control installed recently.
Also, the "Send Error Report" never worked.
The error completely freezes SSMS as it is a modal.
It has to be dismissed multiple times and then navigated away from the selected database back to a server's name - quickly using a keyboard.
1 vote -
don't do auto completion when renaming
When renaming a table alias, or a variable, sometimes you want to rename it to something and SQL Prompt will intercept the return key (to accept the rename) and "auto correct" it - for example, this morning I wanted to change a table alias to "l" and it auto corrected this to "LEFT", so I had to change it back and press enter again.
It's not a big thing, just it happens quite a lot and can be aggravating.
2 votes -
"Prompt AI" allow more database objects, or a defined lists of schemas
Tried to test out the new Prompt AI feature and cannot use it to generate SQL as the DB has more than 4000 objects (over 6000 actually). It would be great to limit the schemas within the DB where I want the AI tool to "know about" so that A) it keeps the AI focused on just the schemas it needs to answer most questions and B) it keeps the overall list of objects and time needed to poll them more manageable. In absence of this, allow more objects.
4 votes -
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' endinto 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.fooI 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' endinto something more manageable…
1 vote -
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:
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.
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).
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…
2 votes -
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.
2 votes -
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…
1 vote -
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…
1 vote -
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…
4 votes -
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.
2 votes -
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…
1 vote -
Alignment of nulls
How can we get the following alignment with nulls? Please review the pre & post images attached
1 vote -
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_USERCurrently the formatting process errors out.
1 vote -
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…
2 votes -
Colorize vertical tabs
Tab coloring doesnt work in vertical tabs mode
3 votes -
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" menu1 vote
- Don't see your idea?