Skip to content
← Customer Feedback for Devart

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

(thinking…)

How can we improve SQL Complete?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

62 results found

  1. Synonyms Intellisense

    Please provide Code Completion for Synonyms!

    I have a development database where I created a synonym for every table and view in another database on another SQL server. When I use SQL Complete and type a SELECT statement for a synonym, column names do not appear.

    Please modify SQLComplete to provide column names when crafting a SQL statement for a synonym!

    Thanks!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  2. De-couple execute-current-statement functionality from code completion.

    I like execute-current-statement functionality, but when I disable code completion then execute-current-statement functionality stops working.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →

  3. Ability to select multiple fields from code completion( wildcard expansion)

    Could you please provide the ability to select multiple fields from code completion pop-up( wildcard expansion).

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  4. Add #temp support to the express addition

    Adding limited support for auto SQL complete for column names to be read from #temp table in the express version

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  5. CTR+F12 Options

    Currently in SSMS if you right click on a stored procedure and select modify you get something like this

    ALTER PROCEDURE [dbo].[ProcedureName]

    In SQL complete when use the key commands CTRL+F12 on exec ProcedureName you get this

    ALTER PROCEDURE dbo.ProcedureName

    notice the missing hard brackets.

    I would like an option i can set in SQL Complete to include the hard brackets

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  6. Apply Block Comment to Selection

    Provide a keyboard shortcut that applies block comment characters at the beginning and end of a selected text. Allow customization so that you can specify how many space characters or newline characters you want applied after the beginning comment characters/before the end comment characters.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →

  7. SSMS 20.x support

    SSMS 20.x has been out for a while now, but I am not upgrading until I can install SQL Complete for it, of course ;-)

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →

  8. Execution History by server

    Filter execution history by server that the code has been executed on.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  9. Intellisense doesn't work when using CROSS/OUTER APPLY of a user defined table-valued function

    When filling in the parameters for the TVF and it has been CROSS/OUTER APPLY'd with a table, the intellisense does not show any of the fields from the table even though they are allowed in the TVF. Even if the parenthesis is closed on the TVF, the table's fields don't show up. The intellisense options that come up are the generic list of dbs, tables, functions, snippets, etc.

    E.g. -
    SELECT * FROM Users u
    CROSS APPLY dbo.FindInvoiceFiles([INTELLISENSE DOESN'T SHOW FIELDS FROM Users table]) fif

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  10. SQL Code Completion for INSERT INTO for a declared variable AS a user defined type

    CREATE TYPE dbo.MyType AS TABLE
    (
    MyTypeId UNIQUEIDENTIFIER NOT NULL
    , MyTypeContent1 VARCHAR(20) NOT NULL
    );

    DECLARE @a AS dbo.MyType

    INSERT INTO @a --> Tab-Tab expands just like it does for other table types.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →

  11. Add extended properties for columns in quick info window for table

    When navigating the mouse cursor to a table, display extended properties in the quick info window.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  12. JOIN FIELDS SUGGESTIONS - Enable TAB acceptance of first suggestion

    When PRIMARY and FOREIGN KEYS share the SAME NAME according to best practises allow the JOIN suggestion to be immediatly pick up with TAB.
    Most of the times the good suggestion comes at top on the list and one can allways navigate to a better one if this is the case

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    This can be achieved as follows:

    1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
    3. Select the ‘Tab’ option.
    4. Click ‘OK’.

  13. Fix accidental error message popup acceptance

    When intensely typing a query and SQL complete has an error in the middle of typing, the error popup window steals focus and if a key is pressed as part of the sql query that accepts the restart ssms button, ssms restarts losing the current work.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →

  14. Format temporal tables with table view

    Format the statements with table view

    DECLARE
    @tbl_VentasDetail TABLE (
    Id int,
    VentaDetailID int,
    VentaID int,
    EmpresaID int,
    PuntoVentaID int,
    ProductoID int,
    VentaDetailLinea int,
    VentaDetailConcepto nvarchar(50),
    VentaDetailCantidad decimal(18, 2),
    VentaDetailPrecio decimal(18, 2),
    VentaDetailCosto decimal(18, 2),
    VentaDetailBaseImpuesto decimal(18, 2),
    VentaDetailDescuento decimal(5, 2),
    VentaDetailImpuesto decimal(5, 2)
    )

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →

  15. Execute statements to cursor position

    I would like to have option(keyboard hotkey) that can execute all statements which are above of cursor position including statement with current cursor position.

    I would call this feature: "Execute query to cursor position"

    I think its very helpful while debugging/creating stored procedures or sql queries

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  16. separate options for text case for tables and columns

    I like to have separate options for setting the text case for table aliases and for column aliases.
    Personally I want my table aliases to be in lower case and my column aliases not changed (or starting with initial caps, depending on the project I'm working on).

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →

  17. Close SQL Complete connection to SQL Server when not being used.

    When running sp_who2 I can see tasks for "dbForge SQL Complete" for each user running SSMS even when it's not doing anything. (I guess the connection is pooled between each request that the application needs to make?)

    Anyway, our admins don't like to see all of these jobs just hanging around doing nothing, especially on our live servers. Any chance of turning off your connection pooling?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →

  18. Add Execution Warning if no WHERE clause

    If a person tries to execute a SQL script without a WHERE clause, it would be nice if SQL Complete would display a warning. This would eliminate issues with accidentally updating all records in a table because a where clause was not specified.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  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

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →

  20. We use temporary tables quite a lot, so better implementation for those would be nice. The software has problems recognizing them.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
2 4
  • Don't see your idea?