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

275 results found

  1. Indentation using tabs highly dependent on the settings tab size

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  3. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  4. Now it can format code using only one selected style

    1 vote
    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 →
  5. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    Please perform the following:

    1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Formatting → Profiles’ branch.
    3. Right-click in the ‘Formatting Profiles’ section and select ‘Reset To Defaults’ from the popup menu.

  6. In Argentine by sql complete is imposible, one dollars are 8 pesos. Is realy expensive!! Also, I can't write in a blog about sqlcomplete because I only use it one free month and then I have to unistall it. I don't use linkedin or facebook, so I can't have this excelent tool. I hate people who download pirate things, so I won't dowload it in http://thepiratebay.se

    Maybe, if I start to use it in my work (complete version six months), other people who can buy it like this excelent tool and they'd buy it.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  7. A key combination to enable/disable SQL Complete would be extremely useful simply for those circumstances where it just gets in the way like when you are working on a system with hundreds of databases and they appear in the suggestions. Tony

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  8. when having multiple nested Select Statements, it formats based on the top-most parent Select statement instead of, either the encapsulated statement or the Select keyword.

    Potential idea: If there is a Select keyword, indent appropriate its siblings but if a nested select is included inside one of the sibilings then base its indention key off the new select pattern, and so on.

    For example:
    Select
    Field1,
    Field
    2,
    ( Select
    Field3,
    Field
    4,
    From Table2 ) as Field_5
    From Table1

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  9. see sample code below

    Select
    @Variable1 = d
    ,@Var2 = dsfdasf
    From
    #data

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  10. Display synonyms as tables

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  11. At some point SQL Complete was modified to automatically close parenthesis when writing functions. When I type 'sum(' the close paren is automatically added and the cursor placed within the parens. This forces me to resort to using the arrow keys when I am done supplying the function's arguments. I don't type with arrow keys, and would like the ability to disable this functionality.

    1 vote
    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 →
  12. I am big fan of this SQL Complete tool, it is really a good tool to help develop or build sql blocks. But one thing i notice that, currently sql complete is not providing intellisense for store procedure parameter. if it is providing this thing also than its really help full while building store procedure.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  13. Redgate has this, infact many of the online SQL formatters give you the option to have keywords, etc as lowercase, capital or uppercase.

    Your product is reasonably priced against redgate.

    But it's unusable if it makes all my keywords uppercase.

    Thanks,
    Jason

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    This can be setup as follows:

    1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Formatting → Profiles’ branch.
    3. Select the active profile.
    4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
    5. Expand the ‘Text Case’ node.
    6. Expand the appropriate subnode and select the ‘Lower’ radio button.

  14. If the word I manually type matches an AutoComplete entry, apply the case in the AutoComplete to the typed word. This would apply to both reserved words and object names.

    Example 1: I type 'sel' and wait a millisecond. 'SELECT' appears in the AutoComplete. I press [space] and SELECT is typed for me. Next, I type 'select' and press [space] without waiting. The word remains lower case.

    Example 2:I type 'select * from peo' and wait a millisecond. 'People' (a table name) appears in the AutoComplete. I press [space] and 'People' is typed for me. Next, I type I type…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  15. Need a format rule for CREATE TABLE.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  16. ability to create some snniped

    1 vote
    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 →
  17. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  18. Please add support for formatting table variable like other table similar format:

    Declare @tbl_MyTable Table (
    Id int,
    Code nvarchar(50)
    )

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  19. While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or to browse to the object.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  20. I want to be able to insert the 'AS' clause before all aliases. Currently, SQL Complete does not insert the 'AS' clause.

    1 vote
    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 →

    The ‘Automatically generate AS clause’ option is available in the ‘Alias’ section of the ‘Options’ window that can be invoked by selecting ‘SQL Complete → Options’ from the main menu.

  • Don't see your idea?