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

269 results found

  1. For example, when I attempt to write out this query:

    SELECT t.Column1 FROM dbo.Table1 t

    As soon as I type "SELECT t." the "t" turns into whatever object name matches t the closest (in my database's case, it's some random UDF). I want to write "t.Column1" before I've specified what t is.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Option for removing trailing spaces

    3 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. To prevent a snippet from getting inserted when the alias is the same as a snippet. Many times I will start a query and an alias is the same as the snippet. When i hit tab or enter that snippet in inserted in place of the alias. This is especially true when you have SSMS Tools installed and many of the snippets from it are one letter (s for select, e for execute and so on)

    3 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Click in Document Outline window on some outline shows code line in sql file. But it would be nice to highlight encapsulated outline after clicking in sql code file on some code line. Therefore the position in navigation tree will be clear everytime.

    3 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Option to have a paragraph, not just a break, between elements of the statements:

    SELECT field1

    FROM table

    WHERE field1 IS NOT NULL;

    3 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Current formatting:

    ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid

    Expected:

    ON (e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid)

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. SQL Complete (or SSMS) does a nice job of highlighting like words. Put the cursor on a table alias, and all occurences are highlighted for example.

    Is it possible to edit all of these like Delphi's Sync Edit feature? Sometimes I would like to edit all occurrences and other times, just those in the highlighted text.

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. so when typing a query that has a JOIN, SQL Complete does a great job guessing what to join ON. However, after typing the ON keyword in the join statement, SQL Complete pops up with list of candidates, and the first one in the list is usually what I want, but it is NOT SELECTED. so I have to take my hand off the keyboard, and select it (or hit the down arrow key), then hit TAB.

    Why interrupt the devs flow? Just auto select the first one in the list!

    3 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. There are a couple ways of doing this now in Visual Studio (Microsoft's own Productivity Power Tools 2012 is one), but none that work in SMSS. I would dearly love the ability, after custom-sorting my tabs, to be able to move forward and backwards through them in the displayed order.

    Currently you can only move through your tabs in the order you last clicked on them -- similar to Alt-Tab in Windows -- but not necessarily in the order they appear visually. I'm thinking Firefox/Chrome/Internet Explorer-type "sensible" tab movement.

    devart will be my eternal hero if SQL Complete had the…

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. SQL Treeo offers some great functionality that really should be integrated with a tool like this, ie dynamic grouping of objects. When dealing with lots of objects in object explorer, it would be amazing to have functionality to group node objects by schema or by custom designation. I have a free open source version I'm using called SSMS Extender 2012, but again, implementation by SQL Complete would be a great feature and I guarantee would make more folks consider your product!

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Already the best formating add-in, but please make it truly complete with these few additions (some are from ApexSQL Refactor) to make it really perfect, thanks.

    • Line break immediately after WHEN, WHILE, IF keywords (to be more consistent like WHERE, HAVING, ON), and then indent their conditions.

    • Do not use a line break before the first item (or remove the existing one) if there is only one item (like SELECT with only one column).

    • Always use BEGIN / END for IF / ELSE, WHILE (add if missing).

    • Always use INTO for INSERT (add if missing).

    • Always use AS for aliases…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. In our company we are working with SAP Business One (SBO). SBO has a fixed database stucture which may not be changed at all. Relations are not directly built into the database.

    A custom relation mapping feature would help us with correct suggestions for the databases while still maintaining the database structure as it is.

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. I would like to format the comments that appear at the end of a line as part of the "stack columns" and "Table View".

    The stacking and table view for comments should have similar behavior as the column and alias view. They appear column aligned.

    Example (because posting destroys the formatting of my post, I'll use "." for spacing):

    SELECT
    .....column1.....AS a.........-- CommentA
    .....col2............AS b........ -- CommentB
    .....col3........... AS abc.....-- CommentC

    Thank you. Jake.

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. I like to capitalise 'begin' and 'end' in lower case so my code looks like this:

    IF @Return = 1
    begin
    SELECT Name FROM Table
    end
    ELSE
    begin
    SELECT 0
    end

    The begin and end words should not be as bold as the sql statements, a bit like curly brackets are.

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. It would be nice to have smarter subquery intellisense that works like the joining intellisense that suggest matches based on column names.

    E.g.
    SELECT * FROM Users WHERE EXISTS (SELECT 1 FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID AND UserRoles.RoleID = 1)

    E.g.2
    E.g.
    SELECT UserID, UserName, (SELECT COUNT(1) FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID) AS NumberOfRoles FROM Users

    3 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  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. In Visual Studio there is a plug that allows you to have the document tabs down the right hand side, which when you have loads of files open is very useful, especially now we have widescreen monitors. However SSMS is behind the times and the tabs along the top isn't enough. Can you please add a feature to display the sql tabs down the side rather than the top.

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. I would be helpful to be able to hide ID or partitioning columns that may not ever be needed when selecting data. They just get in the way when expanding SELECT * but are still necessary to the table structure.

    3 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?