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

309 results found

  1. Let's assume, a user have about 10 most frequently used templates that do not need to be modified after they have been inserted unlike snippets.

    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)
  2. Option to have a paragraph, not just a break, between elements of the statements:

    SELECT field1

    FROM table

    WHERE field1 IS NOT NULL;

    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)
  3. You type in an insert statement. " Insert into dbo.Party" and then press tab. The below code is generated

    INSERT INTO Party
    (
    PartyTypeId,
    TenantId
    )
    VALUES
    (
    0 /* PartyTypeId - INT NOT NULL /,
    0 /
    TenantId - BIGINT */
    )

    Because most of the inserts, updates etc are mostly used inside stored procedures, and the values come from variables, I would like it to show :

    INSERT INTO Party
    (
    PartyTypeId,
    TenantId
    )
    VALUES
    (
    @PartyId /* INT NOT NULL /,
    @TenantId /
    BIGINT */
    )

    An updated statement will do the following snippet :

    UPDATE Party…

    4 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)
  4. Click in Document Outline window on some outline shows code line in sql file. But it would be nice to highlight encapsulated outline after clicking in sql code file on some code line. Therefore the position in navigation tree will be clear everytime.

    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)
  5. I need fast way to format selected text using several formatting styles, specified previously.
    The formatting style specified manually into hotkey (for example, Ctrl+K, Ctrl+F, Ctrl+1 - first style, Ctrl+K, Ctrl+F, Ctrl+2 - second style and etc.).

    If I see a very long value clause:
    INSERT INTO dbo.Table
    VALUES ('111111','222222','333333','444444','555555')
    I select the code and apply another style like this:
    INSERT INTO dbo.Table
    VALUES (
    '111111',
    '222222',
    '333333',
    '444444',
    '555555'
    )

    The hotkey Ctrl+K, Ctrl+F, Ctrl+1 is very hard to push, it is for example.
    Maybe you will think of a more simple alternative, but of course without mouse usage.

    2 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)
  6. It must be also possible to insert a snippet into the currently open editor window by just double-clicking it in the Snippet Editor (left pane)

    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  ·  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. Currently SQL Complete has an option to automatically qualify column names. Unfortunately, turning the option on means turning it on for everything.

    I love that SQL Complete qualifies the column name with the table name in regular SELECT statements such as:

    SELECT t1.Column1, t2.Column2 FROM dbo.Table1 t1 JOIN dbo.Table2 t2 ON t1.Column1 = t2.Column1

    However, I find it unnecessary when you are dealing with only one table in an UPDATE/INSERT/DELETE statement. For example qualification is unnecessary in the following statements:

    UPDATE dbo.Table1 SET Column2 = 123 WHERE Column1 = 10
    or
    INSERT INTO dbo.Table1 (Column1, Column2) ...
    or
    DELETE FROM…

    4 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)
  8. For example, when I attempt to write out this query:

    SELECT t.Column1 FROM dbo.Table1 t

    As soon as I type "SELECT t." the "t" turns into whatever object name matches t the closest (in my database's case, it's some random UDF). I want to write "t.Column1" before I've specified what t 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…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Option for removing trailing spaces

    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. Automatically propose join tables when JOIN instruction is typed.
    Proposal should not be baseed on existing tables relationships since most ERP out there do not have such relationships within the database.

    What I would like is that the user can configure all joins he knows for each tables and when the user types a SELECT instruction with JOIN that SQL Complete propose the list of all preconfigured joins for the tables already part of the SELECT.

    Ex:
    SELECT fields
    FROM Table1
    INNER JOIN Table2 ON Table1Key=Table2.Key
    INNER JOIN <here SQL Complete> would propose all preconfigured joins for Table1 AND Table2

    4 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)
  11. You can opt to have SELECT, GROUP BY, UPDATE, and other clauses stack their parameters. I think the IN clause should also have this capability.

    6 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)
  12. Show the list of available procedures when start typing a procedure name, for example:

    sp_proc1

    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  ·  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. To prevent a snippet from getting inserted when the alias is the same as a snippet. Many times I will start a query and an alias is the same as the snippet. When i hit tab or enter that snippet in inserted in place of the alias. This is especially true when you have SSMS Tools installed and many of the snippets from it are one letter (s for select, e for execute and so on)

    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)
  14. Currently there is an option in the Code Formatter to word wrap code if it exceeds the right column margin, but that isn't ideal for the instance where you want an individual clause in the WHERE statement to stay on a single line no matter how long they are (makes it clearer what the exact logic is). Disabling this, though, forces all of the columns in the SELECT list to be on one line (I have stacking disabled for the fields). I'd say it is a common enough convention to warrant a special flag just for word-wrapping the columns in…

    11 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)
  15. Example:

    IF 1 = 1
    begin
    SELECT
    'it does'
    print('it does')
    end
    else
    begin
    SELECT
    'it does not'

    print('it does not')
    end

    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  ·  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. hi, I work with MS SQL Managemenet System and a lot of *.sql files for updating databases

    to my specific file can have a lot of lines of code (up to 1000 lines) and navigation and reading becomes tragic - I always manually collapse (press on [-] next to block name) all blocks like CREATE PROCEDURE, CREATE FUNCTION

    I really love your SQL Document Outline feature

    so you can handle another feature 'Collapse all blocks to definition' and simplify the life of a lot of db coders

    Will be glad to be among your clients
    Thank you and good luck,…

    3 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)
  17. Provide a facility for us to easily access our snippets from anywhere and share with the community.The Community should be able to upload or browse for interesting and useful snippets.

    Possibly allow to search for snippets online. much like how VS2010+ allows to find extensions.

    2 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)
  18. This feature will allow set or clear bookmark on a line of SQL code, and allow move to successive bookmarked lines. as in Textpad (Ctrl + F2) and (Shift + F2).

    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  ·  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. A) connection identification
    a.1. paint background on crc24 of @@servername\db_name() with alfha at 15-20%
    a.2. allow a logo on right-bottom from local file or table.field of current connection

    B) if I have mySAP's 18.000 objects....
    b.1. allow completition ondemand on key (TAB) with rotation searching:
    objs: tblarc1, tblarc2, ...
    select * from arc{1°TAB} -> tblarc1 {2°TAB} -> tblarc2
    (can rotate or use SHIFT+TAB to go back)
    b.2 show tooltip with complete list of fields when mouseon obj/sp/fn/etc. identifier (of course the info gathering come from a separated thread or stop if mouse exit from tooltip area)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 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. An option to not suggest other databases while populating the suggestion dropdown would be nice. In our system, we have discrete databases for each client, and so our development machines have hundreds of databases on them. When attempting to type a table name, it is not uncommon for SQL Complete to suggest a database name that matches the abbreviation, but for our use case this will never be ideal (queries are basically never ran across databases, and when they are we can deal with having to manually type out the database name).

    At the very least, I think it would…

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