231 results found
-
9 votes
-
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 -
when you search a field to join 2 tables, it would be more convenient if key fields stood on top
when you search a field from suggestion list to join 2 tables, it would be more convenient if key fields were displayed on top
9 votes -
9 votes
Version 3.0 is on the site
-
Add shortcut ctrl + k + d like Visual Studio
Add shortcut ctrl + k + d like Visual Studio for format document
9 votesSQL Complete v2.0 is on site!
-
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 -
Place "AND" logical operator in "JOIN" clause on new line
For readability it would be great if the "AND" operator in a join clause could be on a new line. We currently have:
FROM
TABLE A
INNER JOIN TABLE B
ON B.KEY = A.KEY AND B.DATE = A.DATE AND .......... etc.Would be nice if we can have:
FROM
TABLE A
INNER JOIN TABLE B
ON B.KEY = A.KEY
AND B.DATE = A.DATE
AND ......... etc.8 votes -
Allow JOIN statements to be indented after selecting place on new line
Currently large join sets all align with the from statement making it harder to read.
8 votesVersion 3.0 is on the site
-
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.
-
Allow for a shared formatting file
In an office environment, it may be useful to use the same formatting file across multiple machines. This will be used on a read-only basis (but could be created by exporting it, so the manager can create or update the file).
Using a shared file rather than exporting and emailing the file to be imported would mean that changes made by the manager would be instantly reflected for all users in the dept.8 votes -
Format first row in stacked list with leading space
You should be able to add a leading space for the first row in a stacked list with leading commas, so the column names would be evenly aligned.
8 votesThis feature is implemented in version 4.8 and applies when the ‘Stacked List → Place comma before item in stacked list’ and ‘SELECT → Select List → Line break before first column’ options are selected in the ‘Edit Formatting Profile’ dialog.
-
integrate SQL Complete with
I just purchased dbForge Data studio and dbForge SQL complete. I'm suprised that SQL complete does integrate with data studio.
Why don't you integrate SQL Complete with data studio?7 votesVersion 3.0 is on the site
-
Allow for customizable indentation
Allow to specify code blocks that should be indented
For Example:
begin try
{indented code}
end try
begin catch
{indented code}
end catch7 votesThis feature has already been implemented. But it’s available only in Standard edition of SQL Complete.
Free edition has restricted formatting options. -
"Generate Script As" to Clipboard
"Generate Script As" right now creates a new window which is annoying in most cases because you most likely want to use it in some other script. It would be very useful to have an option to copy it to Clipboard instead of a new window. I would prefer to copy it to Clipboard in 95% of cases.
It might be an option in settings or another menu item.
Thank you in advance.
7 votes -
Select columns from columns list using keyboard shortcut
When typing a select statement, the columns list is nice but to select several fields quickly I have to use the mouse.
Ideally, I'd be able to use the keyboard, I'd scroll down the column list and then press some keyboard shortcut (alt+enter, alt+space) to quicky insert one field, hit down arrow, alt+enter the second field. All without using the mouse
7 votes -
Support for ALTER TABLE statements
Support for ALTER TABLE statements
For example if I type in "ALTER TABLE " I don't get the list of tables in the database (as I would if I typed "UPDATE " for example). Similarly if I then type "ALTER COLUMN " I don't get prompted with column names (as I would if I typed "UPDATE MyTable SET ").
Lastly if I try and format an ALTER TABLE statement it all gets put on a single line. It would be nice to be able to format an ALTER TABLE statement on multiple lines, for example breaking before an ALTER COLUMN…
7 votes -
Copy to Clipboard from Execution History
Currently, you can only open query from Execution History as new query window. It would be useful to have the ability just copy the full or part of the query to the clipboard.
Thank you in advance.
7 votesPlease right-click the query in the ‘Execution History’ window and select ‘to Clipboard’ from the popup menu.
-
Indent table after FROM
Treat FROM and JOIN as equals be able to indent table names ex:
FROMTableA
JOIN
TableB6 votes -
6 votes
-
Option not to add space after function name before parenthesis
Original:
select sum(abs(i)) from dummy
After formating:
SELECT sum (abs (i)) FROM dummy
Optimal:
SELECT sum(abs(i)) FROM dummy6 votesIncluded into SQL Complete v2.50
- Don't see your idea?