275 results found
-
Display Synonyms
Display synonyms as tables
1 vote -
Extended Outline - Custom Collapsable Regions (like C#) with Comments
Introduce Regions like #region in C# for collapsable sections. This regions should have a "name" or comment and should be displayed in document outline for navigation. This has lot of benefits in large sql code files for better orientation and navigation.
41 votes -
Support adding a numeric value next to new line or indent setting
Support adding a numeric value next to new line or indent setting so users could add 1-9 new lines or indents.
3 votes -
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. -
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!
-
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 -
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 -
Custom Alias Map - Tell SQL Complete to always use a specific alias for specific table
I have a table (ObjectReference) and Sql Complete maps it to or1. I understand why it adds the 1 to avoid using the "or" keyword, but it would be nice to set up Sql Complete to use a more friendly keyword.
One solution for this would be to allow me to map table names to alliases. Then, any time ObjectRerence is used, it would get oRef (or whatever) from the map.
44 votesTry out the feature in SQL Complete v5.0!
-
Option to align JOIN clause to FROM and WHERE clause
Current formatting:
FROM Person.Person AS c,
---------HumanResources.Employee AS e
---------JOIN Person.Address AS a
--------------ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguidExpected:
FROM Person.Person AS c,
---------HumanResources.Employee AS e
JOIN Person.Address AS a
-----ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid9 votes -
In Argentine People can't buy sql Complete
In Argentine by sql complete is imposible, one dollars are 8 pesos. Is realy expensive!! Also, I can't write in a blog about sqlcomplete because I only use it one free month and then I have to unistall it. I don't use linkedin or facebook, so I can't have this excelent tool. I hate people who download pirate things, so I won't dowload it in http://thepiratebay.se
Maybe, if I start to use it in my work (complete version six months), other people who can buy it like this excelent tool and they'd buy it.1 vote -
Preserve the users cursor location when formatting is complete
When using the format selection command (or the entire document) the cursor position is reset to bottom of the document, instead of preserving the users cursor location. This is confusing as an end user. I'd like to recommend preservation of cursor location in the document.
3 votesThis issue is fixed in the latest build 4.0.72 of dbForge SQL Complete: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Ability to re-open tabs after reboot or after closing SSMS
A really cool addition to Sql Complete would be the ability to re-open tabs after a reboot or even after just closing SSMS.
If you look at good quality text editors such as UltraEdit or even browsers such as Chrome & Firefox, they have the ability to remember which tabs were open.
64 votes -
Segment Formatting
when having multiple nested Select Statements, it formats based on the top-most parent Select statement instead of, either the encapsulated statement or the Select keyword.
Potential idea: If there is a Select keyword, indent appropriate its siblings but if a nested select is included inside one of the sibilings then base its indention key off the new select pattern, and so on.
For example:
Select
Field1,
Field2,
( Select
Field3,
Field4,
From Table2 ) as Field_5
From Table11 vote -
15 votes
This feature is implemented in version 5.0 of dbForge SQL Complete https://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
0 votes
-
Add feature to format code using different styles defined by user previously
Now it can format code using only one selected style
1 voteYou can now quickly change formatting profiles in the popup menu ‘Active Format Profile’.
-
Enable/disable Key combination
A key combination to enable/disable SQL Complete would be extremely useful simply for those circumstances where it just gets in the way like when you are working on a system with hundreds of databases and they appear in the suggestions. Tony
1 vote -
Respect case of declared variables
I have text case for variables set to "do not change", because none of the other options match my rules exactly (e.g. I want "RecordID" not "RecordId").
The problem is that if I declare a variable (or it is an input param to a stored proc), subsequent formatting doesn't respect the casing of the variable as it was declared.
For example:
DECLARE @RecordID int
SET @recordid = 5
Ctrl-K, Ctrl-D should change it to
SET @RecordID = 5
but it does not
6 votes -
Option to set "Do not change" for Identifier Case
When configuring the formatting options I need to be able to set the identifier case to be unchanged (Camel Case in my instance). Table aliases are fine in lower case.
I can't use version 4 of the product without this.
18 votesPlease, download the latest build.
-
Show column sizes in addition to type when hovering cursor over column names
When hovering cursor over column names, it would be nice to show column data types including sizes.
Currently SQLComplete just shows "myalias.columnName(Column)" when hovering, but it would be good to show "columnName (Type, Size)"6 votes
- Don't see your idea?