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.

275 results found

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

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

  3. Bug in SQL Complete when using spatial functions

    I have a Problem with spatial functions when using SQL Complete.
    SSMS 18.12.1 always hangs when geompetry functions are used in query editor and SQL Code Completion is turned on.
    eg.: geometry::STPointFromText(( ...
    I have to kill ssms in Taskmanager to recover.

    Please fix this, otherwise SQL Complete is a great tool. SSMS feels broken without it.

    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  ·  3 comments  ·  Bugs  ·  Admin →

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

  5. Copy as SQL values List

    Would be great to be able to highlight multiple cells in the Results grid and then select "Copy as SQL values List". This would then create a single line, comma-separated list which could, for example, be pasted into a WHERE in () clause.

    Functionality must be able to detect whether you're copying integer or character values etc. If copying character values, SQL Complete should automatically enclose each value with single quotes

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

  6. AS keyword

    Include a formatting option to "Always include AS keyword for aliases". The goal would be to change

    SELECT
    *
    FROM
    [dbo].[Table1] [T]

    into

    SELECT
    *
    FROM
    [dbo].[Table1] AS [T]

    Note the AS added to the FROM clause. This option could be global (Misc group?) or could be a separate option for each relevant clause (SELECT for field names, FROM and JOIN for table names, etc.).

    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 →

  7. Keep the comments when formatting procedures!

    Keep the comments when formatting procedures! IT can't be that all comments are removed by the formatting process! That happens to my code when I execute ALTER PROCEDURE!
    OR: Give me the option to NOT format my code! I use the Express Version.

    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  ·  Bugs  ·  Admin →

  8. Show Est. row count in Table Tooltip at the TOP to avoid truncation

    When hovering over a table name in the editor, show the Est. row count at the "top" of the tooltip rather than at the bottom, currently the tip runs off screen on tables with many columns, causing it to be invisible

    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  ·  2 comments  ·  Features  ·  Admin →

  9. join

    When typing "JOIN [start of table name]" I would like the suggestions shown by SQL Complete to be based on the foreign keys and [start of table name] instead as now, when it highlights the first table based on [start of table name].

    Example:
    in my database I have a UserAccount and a UserSecurityRole table that are joined by a foreign key so when I start typing
    SELECT * FROM UserAccount ua
    JOIN User

    SQL Complete shows all tables starting with "User" but the one highlighted in the suggestions list i UserAccount instead of UserSecurityRole with a foreign key, so…

    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 →

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

  11. Execution History not saving data

    I have a problem with execution history, recently it stopped behaving correctly. So I daily use SSMS and connect to 2 local instances and several other azure instances. When I open the execution history I notices sometimes that I do not have a log for anything for the past 2 days, for example today is 9th of July, and "Execution History" has records for 7th of July.. 8th and 9th are not there.

    Also it is not recording all executions for all servers, so it might record only 1 for a server and several for another. I am not sure…

    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  ·  Bugs  ·  Admin →

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

  13. Snippets - Add Predefined Literals for Date Parts

    I would like to be able to use a different format for the DATE predefined literals than YYYY-MM-DD. It would be helpful to include one for YYYYMMDD ... or have literals for YEAR, MONTH, and DAY so I could create my own combination from them.

    4 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. Alias CTE like tables

    When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue

    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  ·  2 comments  ·  Bugs  ·  Admin →

  15. Server Color

    There is server coloring in the project. But there are only a few colors I can choose. If I can do it like in SSMS Tool Pack, I can choose any color for the server

    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 →

  16. default suggestion even if containing SQL keyword

    Please change the default selected suggestion in the dropdown so that columns in a user table take precedence over SQL keywords.

    For example:
    When a column in a user table begins with the same word as a SQL keyword (for example the field name "Monthly") -- the default selected suggestion when you type the word MONTH jumps to the "MONTH" keyword instead of staying on "Monthly"

    Code example:

    CREATE TABLE #MyTable (Monthly BIT)

    SELECT * FROM #MyTable WHERE M --selection stays on "Monthly"
    SELECT * FROM #MyTable WHERE Mo --selection stays on "Monthly"
    SELECT * FROM #MyTable WHERE Mon --selection…

    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 →

  17. Display what PC an activation is against

    Either display the hardware hash in the about box or show the computer name in the manage license web page

    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 →

  18. SET instead of SELECT whenever possible

    We use SQL Complete to format our SELECT statements. So the following
    SELECT [aField] FROM [dbo].[aTable]
    turns into
    SELECT
    [aField]
    FROM
    [dbo].[aTable]

    However, this stament is then also transferred from
    SELECT @intVariable = 1
    into
    SELECT
    @intVariable =1

    This is messy, so when we're not selecting from a table, we would like SQLComplete to format our that statement into
    SET @intVariable = 1
    In this case it all fits nicely on a single line again.

    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. Named Tabs

    It would be great if you could name the tabs, not just when saving a query

    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 →

  20. table function hint shows wrong parameters

    When selecting from a table function the tooltip shows the return columns along with the parameters at last, which is super confusing.

    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  ·  Bugs  ·  Admin →
← Previous 1 3 4 5 … 13 14
  • Don't see your idea?