74 results found
-
Use icon to denote fields with indexes
When the drop down appears with field names (like when you're typing in a WHERE clause), include a little icon for each field that's the first field in an index (like the key pic when it's the PK).
Being able to say "oh, that one has an index" would help me when trying to figure out how I want to filter things. (aka use "insertedtime" vs "posttime" vs the "start_time"). I'd say to use one icon (maybe greyed out) for non-clustered, and a different (or not greyed-out) icon for the clustered. You already include the field size, so…
16 votes -
Autocomplete stored procedure With DEFAULT Values
When autocompleting a stored procedure statement in the format 'EXEC storedProc @param1 = 0, @param2 0' it would really help if the parameters would initially have the default values defined in the stored procedure (if applicable).
21 votes -
Load suggestions from sql files in Visual Studio/SSDT Projects
Prompt currently needs a database connection to retrieve objects/suggestions from, which it gets from a database project's "Target Connection String".
It would be better if prompt loaded suggestions directly from the sql files in the project without needing the database.
105 votesThomas Walsh respondedThank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Due to a lack of recent interest in this request, we are no longer actively reviewing it and have removed it’s “Under Review” status.
If you feel strongly about having this feature added to Prompt, please continue to vote for and comment on this request.
Kind Regards,
The Prompt Team -
when aggregating add alias
when doing simple aggregation such as sum(column), it would be nice if the column name would be aliased after the agg automatically. if this is a single column in the function then make the alias the column name. when multiple then create square brackets and move cursor into bracket after closing agg with a ")"
13 votes -
Support for PDW (Parallel Data Warehouse, aka APS)
Work at a company where we're adopting PDW. It would be great if I could get intellisense in PDW.
61 votes -
Pin feature for quick info
When the mouse pointer is hovered over a table or stored procedure etc, an intelli-sense like link is shown which can clicked to bring up the object definition, which disappears when something else is selected.
My suggestion would be a pin feature, so that we can keep the object definition quick info box visible on the screen for reference instead of it disappearing.
8 votes -
Add an option to position SQL Prompt popup at a screen edge, rather than at the cursor position.
What is near the cursor tends to be data that should not be covered over. I need to see it in order to complete my statement.
12 votes -
Autocomplete WHERE clauses with variables
It would be neat if WHERE clauses could get autocomplete suggestions with declared variables (or variables that are procedure parameters). Example:
Assume Table1 with one column Column1.
DECLARE @Column1
SELECT *
FROM Table1 T
WHERE T.Column1 = (suggest @Column1, any variable that exactly matches column by name, except @)2 votes -
1 vote
-
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 Server14 votes -
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.
22 votes -
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.
16 votes -
Automatic Suggestion Refresh
If I am running an "ALTER" or "CREATE" or "DROP", etc. Have SQL Prompt automatically refresh suggestions after my call.
17 votesThe team are currently reprioritising this suggestion with a view to picking it up during 2019.
-
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
- Don't see your idea?