13 results found
-
Don't suggest join keys I've already used
After I type
SELECT * FROM sys.indexes i
INNER JOIN sys.partitions p
ON i.indexid = p.indexid
ANDthe IntelliSense still suggests me i.indexid = p.indexid which I've already used. These duplicates can become pretty annoying when multiple columns are used for joining
26 votesThank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.
Please feel free to send us any additional feedback on these topics by commenting here.
Kind Regards,
The Prompt Team -
Intellisense improvement : Write the FROM automatically for the user based on the SELECT
The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking
For Example,
User types:
SELECT Master.Active,Prompt now makes it
SELECT m.Active -- Cursor stays here
FROM Master mWe still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.
Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.
This feature is also more natural to find because the developer…
19 votesThank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.
Please feel free to send us any additional feedback on these topics by commenting here.
Kind Regards,
The Prompt Team -
Allow starting with FROM clause first to make intellisense and query building more natural
Allow starting a query with the FROM clause (ala LINQ) and provide intellisense normally. I would continue normally, right up to the point the user types the select update or delete keywords, at which point you either automagically reposition the keword and cursor to the top of the query, or allow the user to finish and then prompt for query restructuring. This would completely do away with the mucking around of doing a ssf and then going back later to fill in the list! In fact, I'd take it a step further and offer to restructure poorly written queries..e.g., If…
8 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Automatic Alias from Table Name
Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.
eg.
Customer = C
mem_Membership = Mcus_StateCustomer = SC
aReallyLongTableName = RLTN
view_CustomerMembership = CM
5 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Suggest Alias Even When Table Doesn't Exist
When you have a table in a FROM clause that is aliased, but the table doesn't exist, or is a temp table where the creation isn't in the script or is commented out SQL Prompt doesn't even include the alias as a suggestion. I think it should.
You can see my example in this forum post: http://www.red-gate.com/MessageBoard/viewtopic.php?p=46775#46775
5 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Format clipboard for IN query
Often we'll do a query e.g. SELECT Id from Table where param LIKE '%Foo%'
Then we'll want to copy and paste those Ids in to a separate query
DELETE FROM Table WHERE Id in (.......)
It would be good if there was a way SQL Prompt could help format the clipboard paste into a comma-separated list.
(I appreciate this example would be simple to refactor as a JOIN)
3 votesThank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.
Kind Regards,
The Prompt Team -
Select Statements - WHERE clause value suggestion
I would like to get suggestions for the WHERE query value. For example, when querying a dimension table, I would like to receive a selection box with the possible values to enter.
empid firstname lastname
1 Test User
2 Dummy UserSelect * from Table
Where firstname= [Suggestion Box displays the values "Test" and "Dummy" to pick]3 votesThank you for your suggestion.
We’ve reviewed this as part of our UserVoice triage.
Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.
Kind Regards,
The Prompt Team -
Enable SQL Prompt when in the SSMS editor for "right-click, edit table"
When we right-click a table in the object explorer and choose "Edit top 200 rows" (SS2008 onwards), the SQL editor is not the T-SQL script editor so SQL Prompt is unavailable. It would prove VERY helpful to have full SQL Prompt "Suggestions" functionality available.
3 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
"Invalid object" warning with statement that uses linked server
The intellisense will suggest the object as I am typing the linkedserver.db.schema.table in a statement. However, once the statement has been created, the object/columns etc. are underlined in red and hovering over displays the "Invalid object" warning
2 votesThanks for your feedback. This sounds more like a bug, although we’re not currently aware of it.
Please could you raise a support ticket with recreation steps at https://redgatesupport.zendesk.com ?
Thanks,
The Prompt Team
-
Suggestions based on ranking of user input
Track how often columns are joined by the user, and suggest based on common joins (for that user), not just foreign key/name/datatypes.
2 votesThank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
SQL Prompt code completion completely broken for any query after an UPDATE query with USE HINT syntax
SQL Prompt code completion is broken if you use the OPTION ( USE HINT ( ) ) syntax with an update query. To make matters worse, if you are writing a stored procedure, the code completion tools remain broken for every query following the UPDATE statement as well.
This is on SQL Prompt v9.4.15.8960 with SQL Server Management Studio v17.9.1.
Here is a repro:
CREATE OR ALTER PROCEDURE dbo.TestThis
AS
BEGIN
SET NOCOUNT ON;DECLARE @var int;
-- try to do any code completion after this statement
-- only snippets will work
UPDATE TestTable
SET WatchThisBreak = 1
OPTION( USE…1 vote -
keep getting Sql server management studio IsBusy, because of sql prompt
sometimes its counter productive, messing up in the way of regular intellisense
1 voteHi Anvoy,
Sorry to hear you’re having issues with SQL Prompt! This sounds more like a bug than a feature request so I’m going to close this idea – our support site would be a better place to log it: https://redgatesupport.zendesk.com/hc/en-us/requests/new
please include the version of SQL Prompt that you’re using and detailed recreation steps.Thanks,
Aaron. -
Can "Swap order of columns in join clauses" be enabled automatically if upgrading from an earlier version e.g. 5
WIth the change in v6 to default to
SELECT * FROM table1
INNER JOIN table2
ON table2.id = table1.idwhereas previous versions used this format.
SELECT * FROM table1
INNER JOIN table2
ON table1.id = table2.idIf upgrading from an earlier version, can either the swap order option be enabled or at least the user warned during installation that the intellisense options have changed and that queries will be formatted differently.
1 voteThanks for your suggestion Kieron.
In adding this new option, we set the default column order to what we think will be the most useful. If you prefer the old behaviour, select the new option – your option preferences will be persisted when you install new versions of SQL Prompt.
- Don't see your idea?