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
    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. 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
    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)
  3. Support formatting for ALTER TABLE ... ADD CONSTRAINT ... CHECK ... constructions

    0 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. 0 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. 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
    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)
  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
    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)
  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
    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)
  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
    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)
  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
    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)
  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
    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)
  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
    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)
1 2 10 11 12 14 Next →
  • Don't see your idea?