230 results found
-
Ability to select different formatting for alias and schema
The only deal breaker is the inability to generate upper case table alias, without also making all schemas uppercase.
18 votesThis is governed by the option ‘Generate aliases in UPPER case’ that is in the ‘Alias’ branch of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
Allow user to disable automatic close parenthesis functionality
At some point SQL Complete was modified to automatically close parenthesis when writing functions. When I type 'sum(' the close paren is automatically added and the cursor placed within the parens. This forces me to resort to using the arrow keys when I am done supplying the function's arguments. I don't type with arrow keys, and would like the ability to disable this functionality.
1 voteThere is a setting ‘Add parentheses when inserting function’.
-
Add a lowercase option in the SQL Formatter
Redgate has this, infact many of the online SQL formatters give you the option to have keywords, etc as lowercase, capital or uppercase.
Your product is reasonably priced against redgate.
But it's unusable if it makes all my keywords uppercase.
Thanks,
Jason1 voteThis can be setup as follows:
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.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Expand the ‘Text Case’ node.
6. Expand the appropriate subnode and select the ‘Lower’ radio button. -
Need ability to give intelliSense for store procedure parameter
I am big fan of this SQL Complete tool, it is really a good tool to help develop or build sql blocks. But one thing i notice that, currently sql complete is not providing intellisense for store procedure parameter. if it is providing this thing also than its really help full while building store procedure.
1 vote -
Suggestion: Option to switch between select format styles
Here is a suggestion to allow the formatter (to be set to and) to automatically change the formats of declaring a field name and its definition.
i.e.
Style 1: select [field1] = a+b
Style 2: select a+b [field1]
Style 3: select a+b as [field1]23 votesA possibility to switch between formatting styles is added.
-
Save Execution History
Save a history of your executed SQL statements and allow you to search that history.
Also save the current session so when you open SSMS you can click a button to open all the queries you has open when you last closed SSMS.
55 votes -
INSERT: Stack values on a row basis
It would be nice if INSERTs could have the VALUES stacked on a row basis. E.g.:
INSERT table (col1, col2)
VALUES (''val1", 2)
, (''val3", 4)
, (''val5", 6)4 votes -
Tag block of code to exclude from or use different formatting
Allow adding special tags as comments before a block of code (begin - end) to exclude it from being formatted (just indent the whole section together to proper indent level), or perhaps to signal to use a different formatting profile.
i.e. /format exclude/ or /format profile 2/
8 votesWe would like to let you know that we have released dbForge SQL Complete, v4.5.167 Beta where the ‘Do not format tag’ feature is implemented http://www.devart.com/dbforge/sql/sqlcomplete/download.html
Please see the following examples:
- noformatendnoformat
SELECT a.AbsenceCode, a.Code FROM Absence a
-— noformat
SELECT a.AbsenceCode, a.Code FROM Absence a
/* endnoformat *//* noformat /
SELECT a.AbsenceCode, a.Code FROM Absence a
/ endnoformat *//* noformat */
SELECT a.AbsenceCode, a.Code FROM Absence a
— endnoformatWe will be looking forward to you feedback on the new feature.
-
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*/ a
5 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!
- Don't see your idea?