230 results found
-
Ability to select multiple fields from code completion( wildcard expansion)
Could you please provide the ability to select multiple fields from code completion pop-up( wildcard expansion).
3 votes -
CTR+F12 Options
Currently in SSMS if you right click on a stored procedure and select modify you get something like this
ALTER PROCEDURE [dbo].[ProcedureName]
In SQL complete when use the key commands CTRL+F12 on exec ProcedureName you get this
ALTER PROCEDURE dbo.ProcedureName
notice the missing hard brackets.
I would like an option i can set in SQL Complete to include the hard brackets
3 votes -
Execution History by server
Filter execution history by server that the code has been executed on.
3 votes -
Select and copy from Execution History results
Now it is possible copy all script from Execution History results (to clipboard or new window).
But sometimes it is required to copy just part of the code.
It is possible to select code in Execution History result window, but not possible to copy it.3 votes -
table function hint shows wrong parameters
When selecting from a table function the tooltip shows the return columns along with the parameters at last, which is super confusing.
3 votes -
default suggestion even if containing SQL keyword
Please change the default selected suggestion in the dropdown so that columns in a user table take precedence over SQL keywords.
For example:
When a column in a user table begins with the same word as a SQL keyword (for example the field name "Monthly") -- the default selected suggestion when you type the word MONTH jumps to the "MONTH" keyword instead of staying on "Monthly"Code example:
CREATE TABLE #MyTable (Monthly BIT)
SELECT * FROM #MyTable WHERE M --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mo --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mon --selection…3 votes -
Execution History not saving data
I have a problem with execution history, recently it stopped behaving correctly. So I daily use SSMS and connect to 2 local instances and several other azure instances. When I open the execution history I notices sometimes that I do not have a log for anything for the past 2 days, for example today is 9th of July, and "Execution History" has records for 7th of July.. 8th and 9th are not there.
Also it is not recording all executions for all servers, so it might record only 1 for a server and several for another. I am not sure…
3 votes -
SSMS 20.x support
SSMS 20.x has been out for a while now, but I am not upgrading until I can install SQL Complete for it, of course ;-)
3 votes -
Automatic table alias generation
In FROM clause of SELECT statement automatically generate table alias when table selected from drop-down list.
2 votesSQL Complete v2.0 is on site!
-
qualify names in a sentence, ussing alias (if present) or table name
qualify names in a sentence, ussing alias (if present) or table name
2 votesThis feature is already implemented in SQL Complete 2.0 (Standard edition)
-
A handy feature would be to show a live preview of formatting in the options page.
When selecting the various code formatting options it would be very useful to be able to see the effect in real time of the selections on a sample piece of code. Having to make selections, then close the options and Format the code, then go back and tweak is a bit of a pain.
2 votes -
Do not show intellisense po when indenting code block by TAB
When I pressing TAB button with selected code block to tabify it - intellisense popup opening.
Please, open intellisense popup only if nothing selected.2 votesVersion 3.0 is on the site
-
Improve schema change detection - or provide manual refresh feature
I'm using the free edition. Edited my db schema via die diagram editor, but SQL Complete did not pick up schema changes. Menu only has "refresh suggestions" option but not "refresh intellisense/schema" which I saw mentioned in another user's post.
So, either improve the schema change detection in the free version, or provide a way for the user to refresh manually.
Thanks for a great product.2 votesDescribed problem was fixed right after adding this suggestion. We received a ticket via support system and didn’t notice the suggestion.
-
2 votes
-
Tab ident formatting without space ident at all
Allow SQL formatter to change spaces to tabs and vice versa.
2 votesThis can be setup in the ‘Text Options’ section that can be invoked by pressing down the ‘Show text options’ button on the toolbar of the ‘Edit Formatting Profile’ window.
To open the ‘Edit Formatting Profile’ window, please perform the following:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile and click the ‘Edit Profile…’ button. -
Function names in uppercase
While writing a function name in a query, sqlcomplete force the name to lowercase. In Turkish we have "I" letter and its lower char is "ı" not "i". I mean, when i want to write MIN() function, sqlcomplete replaces with "mın()" not "min()". If you allow function names to be uppercase it would be great. Thank you
2 votes -
Refactor > Change JOIN Order
Would be quite useful to have an option to change the JOIN order of a statement. Say, right click on the statement > Refactor > Change JOIN Order
2 votes -
Separate the formatting options for functions and stored procedures
Function formatting and stored procedure formatting is connected. Stacking a procedure parameter list would be helpful, while allowing function parameters to stay on a single line.
2 votes -
Option between stack or place on single line should be radio button
Option between stack or place on single line should be radio button instead of a check box.
that applies to multiple areas including:
select
common table expressions
from
group by
and order by2 votes -
Bug: subquery select keyword not indented
When option subquery> "line break after open brace" is not selected, the keyword select of the subquery would not be properly indented.
2 votesTry SQL Complete 4.5 beta!
- Don't see your idea?