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

156 results found

  1. When creating a formatting profile there is only one selection for Alias casing, in my personal experience my column alias casing differs from my table alias.

    EX:

    Select
    det.name AS UserName
    , det.id AS UserId
    , det.phone AS UserPhone
    , det.description AS UserBio
    FROM dbo.exampletable det

    when running through my formaterr with the setting Alias Case set to 'Lower' it changes my column alias's whether they are snake_Case PascalCase to lower

    TLDR : have a setting to alter column alias case individually rather than a global alias case option

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Unfortunately, we cannot reproduce the problem. Please, provide us with the following information:
    - which version of dbForge product are you using;
    - the whole script that we need to format (not a part of the code, but the entire document).

    We also want you to check that you are editing the settings for the active formatting profile. Note: the active formatting profile is given in bold in the profiles grid on
    SQL Complete – Options – Formatting – Profiles

  2. I have tab size and indent size both set to 4, so most indented items are indented by 1 tab. This is what I want.

    However, with a stacked list, I want the leading comma to be indented by 1 tab (and the first item by 1 tab plus 1 space).

    At the moment, the commas are indented by 3 spaces. The only way I have found to change this is to set indent size to 5, but that then causes other indents to be 1 tab + 1 space.

    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)
  3. Comment out or remove extraneous commas to prevent a syntax error. Often when I remove several columns I forget to remove the comma on the preceding line.

    Ex. A
    SELECT a,
    b,
    FROM worktable

    Ex. B
    SELECT ,b
    ,c
    FROM worktable

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. In the Alias settings I can choose to use upper case, which is fine, but when I do, all my conditional aliases are also all upper case, I would prefer to keep the upper/lower casing that I specified in the condition/action cells

    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 →
    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.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. It would be great if you could add a 'export query result to Excel' option in SQL Complete Thanks !

    32 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. This will interface beautifully with the rename option that is included with SQL complete. Frequently i'll copy code sets that use two different objects or start as table reads and later become a read from a temp table. being table to change the "from" and easily being able to the rename the alias/table to the new source and have all other references to it be updated as well would be great

    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)

    Could you please provide us an example of this?

    You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

  8. It would be great if you could do SQL file/tab comparison within SSMS.

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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. In the formatting profiles, I would like built-in variables to be all-caps, while user variables left as declared

    e.g. @MyVariable should stay as-is, but @@ROWCOUNT should be all-caps

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Add formatting options specific to Window Functions (e.g. ROW_NUMBER) for line breaks and spacing on the different arguments part of the function PARTITION BY, ROW, ORDER BY etc.

    7 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)
  12. Add the ability to work in a different schema as default from the user's default schema. This will facilitate easier working with schema-less scripting, in a database with multiple schemas with similar/identical table/view setup.

    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  ·  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)
  13. Allow for an alphabetical listing when creating a SELECT list? It makes it difficult to quickly check the checkboxes when quickly adding columns.

    7 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  ·  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 frequently have code like this:

    SELECT *
    into #mytemptable
    FROM mytable m

    and then I remember I need to drop the temp table if it exists.. so I start typing
    DROP TABLE IF EXISTS # when I get to this point, I wish the intellisense would recommend #mytemptable but it only recommends previous #temp tables. I wish for this type of statement, it would prompt for all #temp tables in the query window.

    DROP TABLE IF EXISTS # <-- intellisense here is needed
    SELECT *
    into #mytemptable
    FROM mytable m

    see image... there is no intellisense
    https://imgur.com/a/8xGvfbX

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    dbForge parses the object only after it’s declared. So, if the table is declared in the INTO clause, it will be offered only below the place it’s declared in the script and not above.

  15. Hi,

    I found that full text search intellisense is not there in current version of sql complete, whenever i search for contain or other functions full text search related functions there are not coming in the list. It would be very help full if you can add this feature in next update of sql complete.
    Rest if found anything new enhancements to be made will post.

    Thanks
    Ravinder

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Sometimes we have pre-defined snippets that are already formatted in a specific way, e.g. on one line, and shouldn't get adjusted by formatting.

    To support this, add a couple of checkboxes to snippets:
    [x] Exclude from line-break formatting
    [x] Exclude from in-line character formatting

    The first would cause formatting to ignore the snippet with regards to rules that insert line breaks; the second would cause formatting to ignore the snippet wit regards to non-breaking formatting (case, spacing, etc).

    Common use-case; we have a subquery that gets used a lot to find the max value in a field, and if expanded…

    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)
  17. In the Object Explorer of SSMS I would like the ability to format multiple documents via the context menu.
    The menu item should be available for Database, Views, Programmability, Programmability/Stored Procedures and Programmability/Functions, and should format all documents in the 'folder'.

    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)
  18. It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.

    6 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. When joining tables I often get suggestions by SQL Complete for which tables to join. This is extremely useful and saves me a lot of time. Often times however there are multiple joins I want to make to different tables. But I can only select one join at a time. Selecting multiple suggestions with a ctrl+left click or something similar in the suggestions box would be a great addition for my workflow.

    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. There should be a global empty line management structure for formatting. It would be nice to see:

    - Add empty line before/after keyword
    - Remove empty lines
    - Add empty line between statements
    
    17 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)
  • Don't see your idea?