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

266 results found

  1. 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)
  2. 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)
  3. 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)
  4. 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)
  5. 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)
  6. 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?