275 results found
-
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 -
SQL Code Completion for INSERT INTO for a declared variable AS a user defined type
CREATE TYPE dbo.MyType AS TABLE
(
MyTypeId UNIQUEIDENTIFIER NOT NULL
, MyTypeContent1 VARCHAR(20) NOT NULL
);DECLARE @a AS dbo.MyType
INSERT INTO @a --> Tab-Tab expands just like it does for other table types.
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 -
Apply Block Comment to Selection
Provide a keyboard shortcut that applies block comment characters at the beginning and end of a selected text. Allow customization so that you can specify how many space characters or newline characters you want applied after the beginning comment characters/before the end comment characters.
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!
-
Formatting: Stacked list - Minimum indent
Under "stacked list" group you should be able to specify a minimum indent value (tabs) for the "table view" layout.
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. -
Execute statements to cursor position
I would like to have option(keyboard hotkey) that can execute all statements which are above of cursor position including statement with current cursor position.
I would call this feature: "Execute query to cursor position"
I think its very helpful while debugging/creating stored procedures or sql queries
2 votes
- Don't see your idea?