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.

62 results found

  1. Support SSMS 2016

    Support SSMS 2016 CTP

    33 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 →

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

  3. 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 →

  4. 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 →

  5. 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 →

  6. Display more information about Document Sessions

    Display more information about Document Sessions. Currently, it just has SSMS version and number of files in the session (SSMS 2017 (2)).

    Session Caption:
    1. SSMS Version is close to useless. Because SSMS 2017 provide great backward compatibility with other SQL Server versions. So you don't really need. Please remove it.
    2. Add date and time when the session was saved last time.

    File list:
    3. It would be useful to have server and database next file name.
    4. Each file has backup time but not backup date. Please add it.

    Document Sessions screen:
    5. Revisit design of the Document…

    12 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 →

  7. Copy as SQL values List

    Would be great to be able to highlight multiple cells in the Results grid and then select "Copy as SQL values List". This would then create a single line, comma-separated list which could, for example, be pasted into a WHERE in () clause.

    Functionality must be able to detect whether you're copying integer or character values etc. If copying character values, SQL Complete should automatically enclose each value with single quotes

    10 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  ·  Features  ·  Admin →

  8. 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
    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  ·  Features  ·  Admin →

  9. 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 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  ·  Features  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    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.

  10. Implement code formatting for Merge statements

    Currently, the SQL Formatter has absolutely no options for Merge statements, and they are not formatted very nicely at all.

    Please provide options for formatting all the aspects of Merge statements:

    • Using section
    • WHEN MATCHED section
    • WHEN NOT MATCHED sections
    • Output sections

    Also, if possible, provide the option to have these sections use the same formatting as standard statements. E.g. Update statement in When Matched section uses standard update format, etc.

    6 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  ·  Features  ·  Admin →

  11. Options group for logical operation enclosed in braces

    Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:

    Line break before opening brace
    Line break after opening brace
    Line break before closing brace
    Line break after closing brace
    Indent braces
    Indent logical operation
    Format braces around single comparison operation as in logical operations

    Also, make the same options group for the following predicates:
    - EXISTS
    - ALL
    - ANY
    - SOME

    For details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030

    6 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  ·  Features  ·  Admin →

  12. add a shortcut to do a "edit top 200 rows" on a selected SQL sql statement

    Add a shortcut in the context menu to do a "edit top 200 rows" on a selected SQL sql statement

    5 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  ·  Features  ·  Admin →

  13. Sub condition formatting

    Example of what you can get currently:
    AND
    (
    old.TestString1 != new.TestString1
    ----OR old.TestString2 != new.TestString2
    ----OR old.TestString3 != new.TestString3
    );

    Example of what I'd like to do:
    AND
    (
    ----old.TestString1 != new.TestString1
    ----OR old.TestString2 != new.TestString2
    ----OR old.TestString3 != new.TestString3
    );

    4 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  ·  Features  ·  Admin →

  14. Support dynamic formatting using @SQLComplete tag to override a setting

    There may be times when you would like to switch the formatting for a particular section of code because the global settings would not be most appropriate.

    For example let's stay in SELECT statements you have "Stack Columns" checked with "Simple List" selected. This may be the desired format for 90% of the cases, however when there is a table with a large number of columns(50+), it could be more beneficial to view them on a single line so to see the query as a whole.

    If you could add a comment before the query
    --@Begin-SQLComplete Select-SelectList-StackColumns = True; Select-SelectList-StackColumns-Option=SingleLine…

    4 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  ·  Features  ·  Admin →

  15. Add type into into Tooltip for table column

    It would be very usefull if tooltip (OnMauseOver) for column name in select would also provide info about column type, for example
    [table].[column](column) => [table].[column](column, int)

    4 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. Snippets - Add Predefined Literals for Date Parts

    I would like to be able to use a different format for the DATE predefined literals than YYYY-MM-DD. It would be helpful to include one for YYYYMMDD ... or have literals for YEAR, MONTH, and DAY so I could create my own combination from them.

    4 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  ·  Features  ·  Admin →

  17. Autocomplete picklist wider

    If would be great if the autocomplete pick list was resized sqlcomplete would remember this size change.

    4 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  ·  Features  ·  Admin →

  18. Add extended properties for columns in quick info window for table

    When navigating the mouse cursor to a table, display extended properties in the quick info window.

    3 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 →

  19. Add #temp support to the express addition

    Adding limited support for auto SQL complete for column names to be read from #temp table in the express version

    3 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 →

  20. JOIN FIELDS SUGGESTIONS - Enable TAB acceptance of first suggestion

    When PRIMARY and FOREIGN KEYS share the SAME NAME according to best practises allow the JOIN suggestion to be immediatly pick up with TAB.
    Most of the times the good suggestion comes at top on the list and one can allways navigate to a better one if this is the case

    3 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  ·  Features  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    This can be achieved as follows:

    1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
    3. Select the ‘Tab’ option.
    4. Click ‘OK’.

← Previous 1 3 4
  • Don't see your idea?