Skip to content
← Customer Feedback for Devart

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

(thinking…)

How can we improve SQL Complete?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

278 results found

  1. The first entry in the suggest list dropdown should chosen automatically

    The first entry in the suggest (intellisense) list dropdown should chosen by default.
    This will speed up my typing as the 1st word at the top is typically is the best fit, but to chose it I need to move my mouse or the down arrow key to actually choose it.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Features  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    This is governed by the option ‘Select items in the list if a user input is expected’ that is in the ‘List Members’ branch of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).

  2. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  3. Reverse order of ON clause

    Auto-complete always enters an ON clause as:

    SELECT * FROM Table1
    INNER JOIN Table2 ON Table2.Value = Table1.Value

    This is really annoying to me. I would like an option to reverse the ON clause so it completes like this.

    SELECT * FROM Table1
    INNER JOIN Table2 ON Table1.Value = Table2.Value

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →

  4. automatic insert table alias on columns

    when typing a query have the table alias inserted before the column automatically. For example, in the query below, the t. will automatically get inserted before the column names after the table with an alias is entered.

    Select t.column1, 1.column2
    from tablename t
    where t.column1 = @value

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →

  5. mouse over

    On mouse over column or variable, show datatype full . Ex: varchar(nn), bigint NOT NULL primary autoincrement has index has unique has clustered...

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Features  ·  Admin →

  6. Autorefresh db objects

    Autorefresh db objects data held in cache.

    I have to manually refresh to see new objects or changes to existing objects - it does not automagically detect changes. It could, by reading the datemodified in sys.allobjects and searching for ones newer than last refresh.

    ALGORITHM: If more than one minute (configurable, can be 0) from last refresh, SELECT ... FROM sys.allobjects WHERE modifydate &rt; @LastRefreshTime If any objects found, refresh ONLY THEM. This is very fast, and you will have allways current data.

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Admin →

  7. Highlight all occurrences of selected word

    Highlight all occurrences of a selected word in the current document.

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Admin →

  8. A view of the document structure, so you a overview of the procedures of a file

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Admin →

  9. Synchronize "Refresh Local Cache" with "Refresh Suggestions"

    Guys,
    Synchronize SQL Complete "Refresh Suggestions" command with built-in "Refresh Local Cache".

    Overwise, It's always needed to click both of these commands (first refreshes intellisense, sencond refreshes error highlighing)

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →

  10. Insert Script generation for row/rows

    I would love to see an option where you can right click on a row and say generate insert script for the row. You could also extend this to select multiple rows and limit column selection.

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →

  11. Highlight paired braces, begin/end, etc like SSMS does.

    SSMS editor will automatically highlight paired parentheses and BEGIN/END when one is selected. Very useful in complex statements.

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  12. 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 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

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

  13. Option to set "Do not change" for Identifier Case

    When configuring the formatting options I need to be able to set the identifier case to be unchanged (Camel Case in my instance). Table aliases are fine in lower case.

    I can't use version 4 of the product without this.

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →

  14. Support INSERT/UPDATE statements within MERGE statement

    Provide the column list for the INSERT/UPDATEs within the MERGE statement.

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  15. Active Directory Integrated Authentication

    We'd like SQL Complete to work with (Azure) Active Directory Integrated Authentication

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  16. checkboxes to select what columns you want to select

    when you need to select a column from a table for anyreason. have them listed with checkboxes so you can just selected the ones you want included and they will be insterted into your query.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →

  17. Option to put commas at beginning of line rather than end

    For example:

    SELECT Col1
    , Col2
    , Col3

    etc.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Admin →

  18. Autocomplete functions with braces

    When autocompleting a parameter less function like say: getdate, include also the braces () and put the caret after the closing brace so you can continue typing without having to type the braces youself

    When autocompleting a function with parameters, also automatically put the braces, but place the caret in between the braces (<caret here>) so you can directly start typing the parameter.

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →

  19. Ability to copy a value in the grid along with the column it belongs and formatted for WHERE clause

    For example, let's assume this is the output from a query:

    id name role

    1 Torn ADMIN
    2 John CLERK
    3 Adam SUPER

    I would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.

    In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
    name = 'Adam' and role = 'SUPER'

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Features  ·  Admin →

  20. "Run Current Statement" Suggestions

    1. I use Oracle SQL Developer more than SQL Server Management Studio, and constantly find myself attempting to use Ctrl-Enter in SSMS to execute the current statement, instead of the existing shortcut of Ctrl-Shift-E. Since Ctrl-Enter in SSMS currently appears to provide the exact same functionality as does the Enter key alone, could Ctrl-Enter perhaps be an additional (or alternate) shortcut for "Run Current Statement"? I can't think of any reasons why there would be any objection to this, but if there are, perhaps this functionality could be turned on or off via an Option.

    2. If a SELECT statement ends with…

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →
2 4 5 … 13 14
  • Don't see your idea?