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. Execute Current Statement is a great feature to test out a statement currently being worked. Sometimes I like to break a statement out to its own query window for further development.
    Copy (or Cut) Current Statement would work just like Execute Current Statement except it would copy (or cut) the statement to clipboard instead of executing it.

    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)
  2. Today, SQL Complete supports filtering the AutoComplete list by typing the initials of CamelCase identifiers. In Resharper, you can type any sequence of characters from the member you are looking for, and the autocomplete list is filtered by any members which contain the character you typed, as long as they appear in the same order you typed. This makes it easier to find what you are looking for, because it's easier to type parts of words than to remember the exact words and their initials.

    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. Exclude columns [v].IDENTITYCOL, [v].$IDENTITY from select when checking the table checkbox on the suggestion popup window

    example:
    SELECT [v].id, [v].name, [v].IDENTITYCOL, [v].$IDENTITY FROM table [v]

    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)
  4. When starting visual studio with SQL Complete, it takes 15 seconds more to open Visual studio.

    Maybe you can change to load the data after visual studio is opened? That way the delay is not visible to the user.

    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)
  5. Code preview when hovering a tab or session in the "Documents Sessions" window. I often have several tabs open at once and they are all called "SQLQuery#.sql" which doesn't help. Allow me to see what code is in the tab by hovering it, or ctrl+tab or like tabing through windows or hovering windows in the taskbar in Windows.

    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)
  6. I like the option to align assignments in SELECT, UPDATE, etc, but I don't like that the alignment happens after the equals sign. It's much neater and easier to read when each column is aligned with an equals sign for the assignment.

    (It's for this reason we use equals for column aliases rather than AS)

    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)
  7. 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)
  8. 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)
  9. For example:
    I have such code:
    CREATE PROCEDURE dbo.Proc9999999
    AS
    BEGIN
    SELECT 1
    END
    --many empty lines here

    GO

    Here what I will get after formatting:

    CREATE PROCEDURE dbo.Proc9999999
    AS
    BEGIN
    SELECT 1
    END
    GO

    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  ·  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. 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)
  11. Now, each time I want to search in Execution History I need to type keyword I want to find. It would be nice that it would be store last X searched keywords and it would be possible to select from drop-down menu those items

    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)
  12. I am missing a search box in the list snipets

    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)
  13. It would be really useful if the option is added to see NULL & NOT NULL Count info on the Grid aggregates info-bar along with other aggregates. This will save a lot of time in finding any null value if presents in large data result set.

    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)
  14. As a developer, I would like options to format Block Comments.

    Each of these would be check boxes to enable/disable the feature. The last two options would have a text input box at the end to allow the user to enter the character(s)

    ☑Insert empty line before block comments
    ☑Insert empty line after block comments
    ☑Add border above block comments using: *
    ☑Add border below block comments using: *

    Before:

    USE AdventureWorks2012
    GO

    /* First line of a multiple-line comment.
    Second line of a multiple-line comment. */

    SELECT * FROM HumanResources.Employee
    SELECT * FROM Person.Address /*Single line comment*/
    GO

    After:

    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)
  15. As a user it would be helpful to be able to customize how INDEX statements are formatted.

    For example, it would be nice to be able to configure the indent for the second line where the "INCLUDE" statement is as shown below:

    CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
    INCLUDE ([Column4],[Column5],[Column6])
    GO

    Currently, SQL Complete formats the above text pushing the second line all the way to the left as shown below:

    CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
    INCLUDE ([Column4],[Column5],[Column6])
    GO

    I am unable to find a current setting to indent the second…

    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)
  16. It would be awesome, if you easily could select more than one suggestion in the "List Members" dropdown.

    I often need to choose more than one field from a table - and if the table needed isn't the first one, it takes some extra typing to find it.

    One option could be to leave the dropdown open when choosing an item. Another option (Stolen from LinqPad), is to press a dedictated key (½ or ` in LinqPad) which chooses it, but leaves the suggestion list open.

    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. While camel casing matching is extremely helpful, it breaks when adding middle characters to it, perhaps consider adding to it the same way Visual Studio does it, it’ll be much more helpful.

    For example, consider I have a column "FinalSellingFee" and a column "FreeShippingFunction", when I enter "fsf", both appear, now I only want the second, in Visual Studio I'll simply enter "fsfu" (adding a "u" at the end), or "fshf" (adding an "h" after the "s"), and it'll automatically get that I want the second. It makes it so much easier and quicker.

    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. I would like the ability to change the connection on multiple tabs in a single action. Currently, if I am testing in one environment with multiple tabs open, I need to change each connection individually. I would like a way to specify a new connection for multiple tabs.

    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)
  19. 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  ·  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. In SQL Complete, I would love an option that lets you Format Selection but only changes the casing to what you have specified in your active profile. It would leave all other formatting as is.

    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)
  • Don't see your idea?