Skip to content

SQL Complete

dbForge SQL Complete is an intellisense add-in for SQL Server Management Studio and Visual Studio with advanced autocompletion and formatting features of T-SQL code.

To consider your idea as soon as possible, follow the guidelines:
  • Describe the goal you want to achieve and what result you want to get
  • If you have a solution, add it to the description
  • Give examples that we can use to implement your ideas
  • Add one suggestion per post. If you have several ideas, share them in separate posts
  • Add comments to the suggestion

http://www.devart.com/dbforge/sql/sqlcomplete/

SQL Complete

Categories

JUMP TO ANOTHER FORUM

275 results found

  1. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  2. 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.rowguid

    Expected:

    FROM Person.Person AS c,
    ---------HumanResources.Employee AS e
    JOIN Person.Address AS a
    -----ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  3. 9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  4. Space after comma is great, but please add an option for "except when comma is first on a row" (eg. stacked lines).

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  5. Add shortcut ctrl + k + d like Visual Studio for format document

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  7. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  8. 9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
  9. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  10. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →

    This 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.

  11. Currently large join sets all align with the from statement making it harder to read.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  12. 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.field3

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  13. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    We 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:

    - 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
    /
    endnoformat */

    /* noformat */
    SELECT a.AbsenceCode, a.Code FROM Absence a
    — endnoformat

    We will be looking forward to you feedback on the new feature.

  14. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  15. "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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  16. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  17. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. Allow to specify code blocks that should be indented

    For Example:

    begin try
    {indented code}
    end try
    begin catch
    {indented code}
    end catch

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    This feature has already been implemented. But it’s available only in Standard edition of SQL Complete.
    Free edition has restricted formatting options.

  19. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →
  20. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    Please right-click the query in the ‘Execution History’ window and select ‘to Clipboard’ from the popup menu.

  • Don't see your idea?