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

156 results found

  1. I would like the option to specify that queries under a certain number of characters be formatted to be on a single line. This would also apply to subqueries so that if they are over the specified limit it follows the formatting rules already in place for subqueries but places simple subqueries on a single line.

    So

    SELECT
    *
    FROM
    TABLE
    WHERE
    COL1 = 5;

    would become

    SELECT * FROM TABLE WHERE COL1 = 5;

    and

    SELECT
    COL1,
    COL2,
    COL3,
    COL4,
    CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
    FROM
    TABLE
    WHERE
    COL1 IN (
    SELECT
    COLB
    FROM…

    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)
  2. SQL Prompt has a fantastic feature that allows selected text to be wrapped up by pressing control + selecting snippet that utilizes the SELECTEDTEXT value. This is great for wrapping up text in "Begin try", "comment blocks" and other selection oriented snippets.

    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)
  3. Add an option to format JSON output with proper indentation and line feeds

    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)
  4. I would like the options to enable such a setting that when procedures, functions, etc. are opened for editing, all regions would automatically collapse. There could also be a keyboard shortcut that collapses and expands all regions

    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)
  5. I very often use T-SQL to create a series of T-SQL commands to be run.
    I need to ctrl-C+open new window+ctrl-V+F5 to accomplish that, and it works.
    However, a nice feature would be to just be able to select the commands in the query result window, and choose "execution" from the shortcut menu, and have SQL Complete do all the additional work automagically.

    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)
  6. 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)
  7. 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)
  8. I have another tool I'd prefer to use for formatting, but SQL Complete captures the "ctl-k, ctl-f" clicks, preventing me from using the other tool.

    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  ·  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 let us know what version of SSMS or VS you are using?

    Please note that in some versions Visual Studio or SSMS you can redefine shortcuts for the commands of dbForge SQL Complete (the command contain ‘SQLComplete’) in the ‘Environment → Keyboard’ section of the ‘Options’ window that can be invoked by selecting ‘Tools → Options’ from the main menu.

    Also, please let us know what tool you prefer for formatting and why you chose it over dbForge SQL Complete.

    You can reply straight to our support system at supportATdevartDOTcom

  9. I often find when writing queries in the Sql editor that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu

    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  ·  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)

    You could use the snippets functionality of dbForge SQL Complete.

    The snippet can be as follows:
    SELECT TOP $count$ *
    FROM $schema$.$table_name$

  10. I frequently have code like this:

    SELECT *
    into #mytemptable
    FROM mytable m

    and then I remember I need to drop the temp table if it exists.. so I start typing
    DROP TABLE IF EXISTS # when I get to this point, I wish the intellisense would recommend #mytemptable but it only recommends previous #temp tables. I wish for this type of statement, it would prompt for all #temp tables in the query window.

    DROP TABLE IF EXISTS # <-- intellisense here is needed
    SELECT *
    into #mytemptable
    FROM mytable m

    see image... there is no intellisense
    https://imgur.com/a/8xGvfbX

    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)

    dbForge parses the object only after it’s declared. So, if the table is declared in the INTO clause, it will be offered only below the place it’s declared in the script and not above.

  11. When creating a formatting profile there is only one selection for Alias casing, in my personal experience my column alias casing differs from my table alias.

    EX:

    Select
    det.name AS UserName
    , det.id AS UserId
    , det.phone AS UserPhone
    , det.description AS UserBio
    FROM dbo.exampletable det

    when running through my formaterr with the setting Alias Case set to 'Lower' it changes my column alias's whether they are snake_Case PascalCase to lower

    TLDR : have a setting to alter column alias case individually rather than a global alias case option

    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)

    Unfortunately, we cannot reproduce the problem. Please, provide us with the following information:
    - which version of dbForge product are you using;
    - the whole script that we need to format (not a part of the code, but the entire document).

    We also want you to check that you are editing the settings for the active formatting profile. Note: the active formatting profile is given in bold in the profiles grid on
    SQL Complete – Options – Formatting – Profiles

  12. 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…)
    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)

    You might be referring to the Tabs Color feature that can be setup in the ‘Tabs Color’ section of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).

  13. Issue: Formatter, add the ability to configure segment FROM represented JOIN in tabular form.
    Example: http://www.sql.ru/forum/actualutils.aspx?action=gotomsg&tid=976629&msg=16224475

    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)
  14. When a SET statement is a series of concatenated strings and you wrap the elements, the formatter aligns the wrapped strings with the SET keyword. They should have an option to be indented. Note below that periods denote indentation.:

    SET @Foo = @Bar + " some text " + @Baz +
    ......." some more text";

    Is formatted as:

    SET @Foo = @Bar + " some text " + @Baz +
    " some more text";

    Note that the indentation on the wrapped line is removed. It would be nice to have an option that results in:

    SET @Foo = @Bar +…

    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)
  15. when type insert into table then type Tab can get result like bellow
    Declare @SerNo XXX(SerNo RealType)
    Declare @NameXXX(NameRealType)
    Declare @ValueXXX(ValueRealType)
    insert into TestTable (SerNo,Name,Value)values(@SerNo,@Name,Value)

    it's real help for me

    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)
  16. 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)
    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)
  17. Shortcut (Shift+Alt+O) to open an window with the names of all database objects (stored procedures, tables) and a textbox to enter the name (partial, multipart) of the object to find. While typing remove non matched names from the list. When selecting an object open a menu with options like Script Object AS (CREATE, INSERT etc).
    Then open a new SQL Server Management Studio window with the selected SQL code.

    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)
  18. Filter on the toolbar for filtering on all objects. To work in real time as you type. Current filter process is painful.

    Imagine I want to filter SP's, tables, views based on the string 'pack', for stuff like 'vwpackingtray' and 'sppackStrut'. At the moment I have to go to each object type area individually, open a poorly designed dialog, select focus before typing (?), type in the search term and save.

    I want a filter textbox in the toolbar, and as I type in it, the objects across the whole database(s) start to filter down to…

    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)
  19. My company uses SQL code embedded into xml documents which is edited in visual studio, so to format the entire files would be bad. The sql formatter in SSMS is outstanding. It would be nice to be able to format just a selection of text inside visual studio with the sql formatter using my setup profile

    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)
  20. Sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query, taking into account the column aliases. Thus

    INSERT INTO table
    (columnA, columnB, columnC)

    SELECT foo AS columnB, columnC, bar AS columnA
    FROM table2

    becomes
    INSERT INTO table
    (columnB, columnC, columnA)

    SELECT foo AS columnB, columnC, bar AS columnA
    FROM table2

    With a few columns it's no big deal to do it manually but with 20 columns it is.
    Displaying a hint if columns are missing is also welcome.

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