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.

280 results found

  1. Copy to Clipboard from Execution History

    Currently, you can only open query from Execution History as new query window. It would be useful to have the ability just copy the full or part of the query to the clipboard.

    Thank you in advance.

    7 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  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    Please right-click the query in the ‘Execution History’ window and select ‘to Clipboard’ from the popup menu.

  2. Formatting for Synapse

    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…

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

  3. Quickinfo for Objects

    It would be great to have a quick information about the object(structure). For example if you type select * from [mytable], then move with the mouse over [mytable], a small window should appear with all columns + datatypes, default values etc.

    6 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…)
    1 comment  ·  Admin →

  4. Option not to add space after function name before parenthesis

    Original:
    select sum(abs(i)) from dummy
    After formating:
    SELECT sum (abs (i)) FROM dummy
    Optimal:
    SELECT sum(abs(i)) FROM dummy

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

  5. Provide room for SQL Snippets.

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

  6. Product Update Manager Improvements

    It should offer to close SSMS, wait for the save dialog to exit and launch the update.

    Or if that can't be done, it should at least launch explorer with the file highlighted after download.

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

  7. Alias comprise of the first two letters of table name

    Would it be possible to add an option allowing for the alias to comprise of the first two letters of the table name rather than the first, for example:

    dbo.position po
    dbo.product pr

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

  8. Put ON at top of suggestion list when using JOIN

    When typing inner join table1, make the ON keyword display at the top of the suggestion list

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

  9. Respect case of declared variables

    I have text case for variables set to "do not change", because none of the other options match my rules exactly (e.g. I want "RecordID" not "RecordId").

    The problem is that if I declare a variable (or it is an input param to a stored proc), subsequent formatting doesn't respect the casing of the variable as it was declared.

    For example:

    DECLARE @RecordID int

    SET @recordid = 5

    Ctrl-K, Ctrl-D should change it to

    SET @RecordID = 5

    but it does not

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

  10. For debug mode: when user moves mouse cursor to variable name - it's value appears.

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

  11. Show column sizes in addition to type when hovering cursor over column names

    When hovering cursor over column names, it would be nice to show column data types including sizes.

    Currently SQLComplete just shows "myalias.columnName(Column)" when hovering, but it would be good to show "columnName (Type, Size)"

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

  12. Case statement in select clause - using table view

    Select
    c.FirstName
    ,ln = c.LastName
    ,e.JobTitle
    ,d =

    Case
    When a.AddressLine1 = 1 Then 1
    End
    ,a.City As ct
    ,a.PostalCode

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

  13. format selection by a profile I select

    I'd like to select some code, right click, and have menu choices to match my profiles such as:
    Format Selection Horizontal (tight)
    Format Selection Vertical (spacious)

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

  14. Indent table after FROM

    Treat FROM and JOIN as equals be able to indent table names ex:
    FROM

    TableA
    JOIN
    TableB

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

  15. Implement code formatting for Merge statements

    Currently, the SQL Formatter has absolutely no options for Merge statements, and they are not formatted very nicely at all.

    Please provide options for formatting all the aspects of Merge statements:

    • Using section
    • WHEN MATCHED section
    • WHEN NOT MATCHED sections
    • Output sections

    Also, if possible, provide the option to have these sections use the same formatting as standard statements. E.g. Update statement in When Matched section uses standard update format, etc.

    6 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…)
    1 comment  ·  Features  ·  Admin →

  16. mark opening or closing brackets when another is selected

    sql complete doesn't mark openning brackets when closing is selected etc. it's working in SSMS but, when i install sql complete it doesnt'.

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

  17. Options group for logical operation enclosed in braces

    Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:

    Line break before opening brace
    Line break after opening brace
    Line break before closing brace
    Line break after closing brace
    Indent braces
    Indent logical operation
    Format braces around single comparison operation as in logical operations

    Also, make the same options group for the following predicates:
    - EXISTS
    - ALL
    - ANY
    - SOME

    For details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030

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

  18. Suggest JOIN expressions and conditions

    1 In SELECT statement after user types JOIN suggest full clause basing on table foreign keys.
    2. When user types JOIN condition after ON suggest conditions table basing on table foreign keys and matched column names.

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

  19. List members for CTEs

    List members for common table expressions

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

  20. Different (or customizable) alias generation

    For table name, for example, 'tMoneyCashOrder', auto-alias should be like 'tMCO'

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