230 results found
-
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’.
-
Support INSERT/UPDATE statements within MERGE statement
Provide the column list for the INSERT/UPDATEs within the MERGE statement.
18 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
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 -
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).
-
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 -
Ability to expand columns when typing UPDATE statements (similar to INSERT)
- Let's assume we have a table:
CREATE TABLE dbo.Employee
(
EmployeeID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
IsMainWorkPlace BIT NOT NULL,
TabelNumber VARCHAR(6) NULL,
PersonID INT NOT NULL,
DepartmentUID UNIQUEIDENTIFIER NOT NULL,
DateIn DATETIME NOT NULL,
DateOut DATETIME NULL,
IsLabourUnionMember BIT NOT NULL,
FiringReasonID INT NULL
)- Let's type the following construction and click TAB at the end:
UPDATE dbo.Employee
- Suggest to expand columns just like it's implemented for INSERT:
UPDATE dbo.Employee
SET
IsMainWorkPlace = DEFAULT /* IsMainWorkPlace - BIT NOT NULL /
, TabelNumber = '' / TabelNumber - VARCHAR(6) /
, PersonID = 0 / PersonID - INT…46 votesMeet the feature in SQL Complete v5.0!
-
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: Stack table view doesn't apply to variable assignments
see sample code below
Select
@Variable1 = d
,@Var2 = dsfdasf
From
#data1 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.
-
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 -
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 -
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 -
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 -
Datepart parameter inside DATEDIFF function adds parentheses
When using the DATEDIFF function for example, the first parameter is a datepart (year, month, day, etc). The code completion for that parameter always adds parentheses after the datepart - e.g. DATEDIFF(YEAR(), Start, End). Is it possible to turn off the addition of the parentheses to the datepart inside a function that has datepart as a parameter?
0 votes -
9 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
- Don't see your idea?