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

271 results found

  1. In a WHERE clause, there is an option to wrap before a logical operator, but then the operator is aligned with the WHERE keyword. I'd like an option to indent logical operators in the WHERE clause, so it's clear that they are under it.

    0 votes
    How important is this to you?
  2. Long standing issue with SSMS 2012 that has still not been addressed by SSMS Team.

    See:
    Shortcut:
    Text Editor::Ctrl+Alt+Space Edit.ToggleCompletionMode Edit.ToggleCompletionMode True

    Toggles completion mode, however doesn't preserve this change for any other session. Very annoying, requiring extra keystrokes each time using intellisense.

    Links:

    http://connect.microsoft.com/SQLServer/feedback/details/686087/intellisense-completion-mode-does-not-persist

    http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/0bd35217-03bc-462c-9491-0cb58aecd38e/

    http://beyondrelational.com/modules/2/blogs/77/Posts/18084/0213-sql-server-2012-ssms-intellisense-completion-mode-feature-a-matter-of-user-preference.aspx
    http://stackoverflow.com/questions/10555138/ssms-2012-intellisense-behavior?lq=1

    You'd be popular if you could keep this mode preference for the user as designated! I would like the first result to be auto selected so I I hit tab it completes. As it is, it requires extra key strokes. Thanks!

    0 votes
    1 comment  ·  Admin →
    How important is this to you?
  3. Support formatting for ALTER TABLE ... ADD CONSTRAINT ... CHECK ... constructions

    0 votes
    0 comments  ·  Admin →
    How important is this to you?
  4. 0 votes
    0 comments  ·  Admin →
    How important is this to you?
  5. Currently, Sql Complete doesn't show intellisense for procs in Master DB when the active connection is in a different database. These procedures are still runnable from any database, so it should still show intellisense. This should be enabled by default or at least have an option in settings.

    0 votes
    1 comment  ·  Admin →
    How important is this to you?
  6. When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue

    0 votes
    1 comment  ·  Features  ·  Admin →
    How important is this to you?
  7. I like BACKUP/RESTORE commands formatted so that all the options (especially MOVE options) are on separate lines in order to enhance readability.

    0 votes
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  8. AutoComplete suggestion: MS Visual Studio does this, you should too.

    • Type in a function name: SQLComplete adds a full set of parentheses: SET X=myFunction()
    • Type in function parameters: SET x = MyFunction(1,2)
    • If user types closing paren, we have two, which is wrong. Current alternative is to right arrow or something to get past it.
    • SUGGESTION: If user types a paren immediately before a paren, skip past the paren instead!

    MS Visual Studio does this and it works great.

    0 votes
    1 comment  ·  Features  ·  Admin →
    How important is this to you?
  9. I often find when writing queries in the SQL edior that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu

    0 votes
    How important is this to you?
  10. This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
    I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.

    0 votes
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  11. With the tab coloring feature, it can be difficult to tell which tab is the currently active tab just by looking at them. Some of the colors of the disabled tabs come through as slightly different than when they are active, but look like they might be active because they are close to other colors.

    I would suggest either making all inactive tabs gray, or to introduce some other type of visual queue to help easily distinguish active from inactive tabs.

    I can't upload a screenshot here but I do have one as an example.

    0 votes
    1 comment  ·  Features  ·  Admin →
    How important is this to you?
1 2 10 11 12 14 Next →
  • Don't see your idea?