275 results found
-
When formatting document or selection, leave cursor on same line on screen
When formatting a document or selection, the line with the cursor is moved as far down on the screen as possible. I would like it to stay on the position on the screen.
As it is now, I have to "search" for the cursor every time I have formatted and often I will have to scroll, since I will typically want to see the code below the cursor.
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 -
9 votes
-
Additional condition for the 'Insert space after comma' formatting setting
Space after comma is great, but please add an option for "except when comma is first on a row" (eg. stacked lines).
9 votes -
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!
-
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 -
Script from Result Window
Shall we give some option to generate the Insert/Update/Delete scripts from the Selected Result Window
For Eg.
SELECT * FROM Employee WITH(NOLOCK) WHERE DepartmentID = 1
Lets assume that, this query returns five recards. The User should able to see Insert/Update/Delete Scripts menu when the User right clicks in the result window.
If the User Clicks Insert, we have to generate the Insert script for the Selected Rows & Columns.
If the User Clicks Update, we have to generate the Update script for the Selected Rows & Columns with the where clause. The where clause should map with primarykey.
If…
9 votes -
9 votes
Version 3.0 is on the site
-
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.
-
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
-
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 -
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.
-
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 -
"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 -
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 -
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. -
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 -
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.
- Don't see your idea?