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

275 results found

  1. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  2. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  3. 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)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Bugs  ·  Admin →
  4. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  5. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  6. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  7. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  8. 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)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Features  ·  Admin →
  9. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  10. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  11. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  12. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  13. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  14. 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)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Bugs  ·  Admin →
  15. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  16. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  17. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  18. 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)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  19. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  20. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
← Previous 1 3 4 5 13 14
  • Don't see your idea?