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

308 results found

  1. I really love the refactoring features, but came across 2 things that might be addressed.

    1. when renaming procedure variable and the same variable name is used in other SP that is called using explicit variable assignment, e.g.
      EXEC dbo.otherSp @variable = @variable,
      the other SP variable gets renamed as well
      (e.g. rename
      @variable to @newName creates
      EXEC dbo.otherSp @newName = @newName
      instead of
      EXEC dbo.otherSp @variable = @newName)
      when variable is part of an EXEC command and parameter contains assignment operator, only the variable following an assignment operator should be renamed

    2. when leaving table alias as it is and changing…

    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  ·  Bugs  ·  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. Create SQL Complete Extension for Visual Studio Code
    More and more I find our developer teams using Visual Studio Code as single IDE for all development and scripting. While the SSMS and Visual Studio extensions are great, most of our developers are not using those tools as much and find it cumbersome to open up the supported IDE's to get SQL Complete's benefits.

    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)
  3. Please add Auto scroll in Messages tab in "Results in Grid" Mode

    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)
  4. Please add the ability to color brackets. Just like it happens in Excel, for example, when you write a function. The opening and closing brackets are marked in one color.

    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  ·  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)
  5. With the tab coloring feature, it can be difficult to tell which tab is the currently active tab just by looking at them. Some of the colors of the disabled tabs come through as slightly different than when they are active, but look like they might be active because they are close to other colors.

    I would suggest either making all inactive tabs gray, or to introduce some other type of visual queue to help easily distinguish active from inactive tabs.

    I can't upload a screenshot here but I do have one as an example.

    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  ·  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)
  6. Enhanced Documents Sessions

    The main issue I have with SQL Management studio is managing all the tabs and code. One great feature would be the ability to automatically group all sessions by the active database. A modern approach would be to have "grouping" tabs, where you can place code, or a tree approach with subtrees.

    The single biggest issue I have is editing stored procedures/functions. If you multiple tabs with the same proc and edit one, then open the other tab and edit by mistake, it is a disaster. Being able to label a session with the actual stored proc…

    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  ·  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)
  7. 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…)
    1 comment  ·  Bugs  ·  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. We have already GitHub CoPilot for Visual Studio.
    Integrate please it also with SSMS. Or directly ChatGPT

    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  ·  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)
  9. Title says it all... Give me the option to insert a line break after SELECT only if a DISTINCT / TOP clause is used.

    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)
  10. I would like an option for column aliases. I would like to choose between = or AS for the "Alias sign".
    The formatting should be done based on this "alias sign" and also be aligned by the alias sign.

    I prefer the = sign , but formatting doesn't seem to accept that as an alias now.

    Example before formatting:

    SELECT colA as [Column A], columnB as [ColumnLonger B]
    FROM Table_1 t

    Formatting when "=" is used as "Alias sign";

    SELECT [Column A] = t.colA
    ,[ColumnLonger B] = t.columnB
    FROM Table_1 t

    Formatting when "AS" is used as "Alias sign":

    SELECT…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 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)
  11. How about making sure that your updates don't break my system when I run update install. Every time I run your release update your install process wipes out my Environment.Keyboard.Query Shortcuts

    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)
  12. column lookups in MERGE statements, like in INSERT statements. Click on a column name to find the corresponding value in the VALUES area.

    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)
  13. Have the ability to train intellisense when joining tables to learn which tables join together.

    so that in the future you can just type:
    "select * from employees e
    left join "

    and intellisense gives a drop down list of related tables, which when selected writes out the table name AND join columns.

    i.e.:
    "select * from employees e
    left join "
    and intellisense suggests: "manager m on m.managerID = e.managerID"

    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)
  14. 9 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)
  15. 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…)
    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)
  16. I have started using Serverless SQL Pool within SSMS. I have seen and voted for a post for Intellisense, but it would be good to be able to format a query too. For example the below query:
    SELECT cast(r.filepath(1) as varchar(100)) as [$FileName], ISNULL(SysRowId,0) AS _SysRowId, ISNULL(LSN,'') AS LSN, ISNULL(LastProcessedChangeDateTime,'1900-01-01') AS LastProcessedChangeDateTime, ISNULL(DataLakeModifiedDateTime,'1900-01-01') AS DataLakeModifiedDateTime, ISNULL(RECID,0) AS RECID, Language, Status, Stage, ISNULL(DataAreaId,'') AS DataAreaId, ISNULL(PARTITION,0) AS PARTITION, ISNULL(RECVERSION,0) AS RECVERSION
    FROM OPENROWSET(BULK 'Tables/StgTable/*.csv'
    ,FORMAT = 'CSV', PARSER
    VERSION = '2.0', DATASOURCE ='wsds', ROWSETOPTIONS = '{"READOPTIONS":["ALLOWINCONSISTENTREADS"] }'
    )
    WITH (
    SysRowId…

    6 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  ·  Bugs  ·  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. Hi, all. I'm really enjoying using SQL Complete. One feature that's been missing from SSMS is a dark theme. There is a way to hack a "dark theme" -- by changing a setting in a configuration file, but it's incomplete; ‘Object Explorer’ and ‘Output Window’ keep their blindingly white backgrounds. Please consider adding this feature to SQL Complete. Thanks

    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)
  18. Example 1:
    If you are using a NOT declared variable @var1, @var1 will get underlined and there is a tooltip with the error.
    On the tooltip there could be a suggestion: "add declare @var1 int".
    Example 2:
    If you are executing a procedure and you are missing some mandatory parameters then there could be the solution "add missing parameters" on the tooltip

    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  ·  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)
  19. We have started using serverless SQL Pool in Synapse, on top of a data lake.

    In SSMS it behaves mostly as a "regular" SQL Server, however intellisense does not work at all with SQL Complete.
    Please implement intelllisense for Synapse.

    9 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)
  20. 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…)
    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)
← Previous 1 3 4 5 15 16
  • Don't see your idea?