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

306 results found

  1. When using the menu option "script object as..."
    1) when creating the new file have the name of the object be the filename. That way it is much easier to find in the tabs of SSMS instead of just another SQLqueryxx.sql file. This would make it much easier to find it again after switching away from that document.

    2) have some option setup to make it always be a create and not an alter. When I use the command its so I can see what the object is, I don't want to accidentally modify it so create means sql server…

    4 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. Formatting for rownumber() seems to have issues with breaking up the line. I don't know if the parser is evaluating it as a possible subquery, but it would be great to have the option for a single line or wrapped line rownumber(). A row_number() statement on 4-5 lines seems to be a little confusing.

    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)

    Could you please provide us a concrete example demonstrating this and describe it in more detail?

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

  4. When installing an upgrade, my additions to the snippets manager are maintained. However, I would like the option to keep all edits I've made to the default set of snippets as well.

    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)

    We just checked and confirm that changes made in the snippets are preserved when upgrading dbForge.

  5. the original sql statment:

    SELECT *
    FROM T1 RIGHT JOIN T2 ON T1.ID1=T2.ID1

    after reorganize

    SELECT *
    FROM T2 LEFT JOIN T1 ON T2.ID1=T1.ID1

    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)
  6. Permitir comparar dos archivos o más objetos por selección; de bases de datos diferentes o de servidores diferentes.

    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. I want to be able to mark cells in the results panel. I often have SSMS open on one screen, and some spreadsheet or notepad open on another. I can select the cells, but then that selection is no longer visible once I go to the other window. I should be able to change the background color or a cell in the results pane by right clicking, and/or keyboard command.

    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)
  8. 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)
  9. 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)
  10. 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)
  11. 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)
  12. 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)
  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. 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)
  15. 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)
  16. 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)
  17. Current formatting:

    ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid

    Expected:

    ON (e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid)

    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)
  18. SQL Complete (or SSMS) does a nice job of highlighting like words. Put the cursor on a table alias, and all occurences are highlighted for example.

    Is it possible to edit all of these like Delphi's Sync Edit feature? Sometimes I would like to edit all occurrences and other times, just those in the highlighted text.

    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)
  19. so when typing a query that has a JOIN, SQL Complete does a great job guessing what to join ON. However, after typing the ON keyword in the join statement, SQL Complete pops up with list of candidates, and the first one in the list is usually what I want, but it is NOT SELECTED. so I have to take my hand off the keyboard, and select it (or hit the down arrow key), then hit TAB.

    Why interrupt the devs flow? Just auto select the first one in the list!

    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. There are a couple ways of doing this now in Visual Studio (Microsoft's own Productivity Power Tools 2012 is one), but none that work in SMSS. I would dearly love the ability, after custom-sorting my tabs, to be able to move forward and backwards through them in the displayed order.

    Currently you can only move through your tabs in the order you last clicked on them -- similar to Alt-Tab in Windows -- but not necessarily in the order they appear visually. I'm thinking Firefox/Chrome/Internet Explorer-type "sensible" tab movement.

    devart will be my eternal hero if SQL Complete had the…

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