280 results found
-
Provide an option to specify leading or trailing commas in SELECT field list
Provide a setting to choose how fields will be inserted into code when hitting tab to change SELECT table.* to table.field1...
Currently it does:
table.field1,
table.field2,
table.field3
It would be nice if it could do
table.field1
, table.field2
, table.field38 votes -
9 votes
-
Bug: Stack table view doesn't apply to variable assignments
see sample code below
Select
@Variable1 = d
,@Var2 = dsfdasf
From
#data1 vote -
Bug: Line breaks removed before comments
New lines are removed between a parentheses or a comma and a comment.
see sample below.
Select * From(
Select 1 a,
--comment after comma - rows above removed 2 t --comment after field - rows above not removed , --sdf 3 g) /*comment after parentheses - rows above not removed*/ a5 votes> New lines are removed between a parentheses or a comma and a comment.
> see sample below.
> Select * From(
> Select 1 a
> ,
> —comment after comma – rows above removedThis issue is fixed in the latest build 4.0.78: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
> 2 t
> —comment after field – rows above not removed
> ,
> —sdfThis issue is fixed in the latest build 4.0.78.
> 3 g)
> /comment after parentheses – rows above not removed/
> aSuch behavior is currently by design. Though, you can carry this issue over to a new suggestion.
-
Case statement in select clause - using table view
Select
c.FirstName
,ln = c.LastName
,e.JobTitle
,d =
Case
When a.AddressLine1 = 1 Then 1
End
,a.City As ct
,a.PostalCode6 votes -
Make Format Selection to format what is actually selected
the format selection does expand the actual selection. Sometimes this is nice as it expands to include other bits that should have been selected but haven't other times it selects more than I want formatted. I think it should really only format what I actually select. Perhaps another option for format selection and related could be added too?
26 votesTry SQL Complete 4.5 beta!
-
UPDATE and DELETE statement understanding table alias
When creating an UPDATE or DELETE statement and referencing a table alias. It cannot understand these. For example:
UPDATE A
SET ID = 5
FROM Table1 A
INNER JOIN Table2 B ON A.ID = B.IDSQLComplete does not understand the alias 'A' when writing the UPDATE or the SET statement.
3 votes -
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
- Don't see your idea?