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

268 results found

  1. User Defined Types seem to have no intellisense or completion. Hovering over them shows no information about them. SQL Complete does not offer to complete the field list when inserting into them.

    This is extremely annoying. Please add intellisense and completion for UDTs!

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. In our schema, we have the unfortunate convention (if you can call it that...) of including underscores in many table and sproc names. For instance, a report sproc might be named ReportSalesByChannel. It would be awesome if the CamelCase interpretation either completely ignored the underscores in the name while providing the suggestions (so typing rsbc would suggest the above named report), or make it so the _ is one of the interpreted characters, which would allow rsbc to again suggest the above sproc. Right now any stored procedure with an underscore cannot be quickly suggested by any abbreviation…

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  2 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)
  3. I have looked high and low for product that will meet a need that I often have; from the number of posts that I find on the net many others have as well.

    More and more, with the increase in the amount of data being collected and queried, data warehouses, BI software, using columnar tables (sometimes referred to as a vertical data structure) makes more since. Vertica DB and Terri Data use this structure natively.

    However, it often is necessary to convert (or pivot) the data to a traditional horizontal, row-based format. In SQL Server as well as Oracle, and…

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Add an option to right-align table aliases in the SELECT list.

    Here is an example:

    SELECT
    -> [alias]->-> -> -> =t.col1
    -> ,[differentlen] -> =t.col1
    FROM table
    name t

    =t.col1 should be right-aligned and stay under each other.

    12 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)
  5. Format SELECT columns. Alias on left object on right separated by aligned " = ".

    e.g.

    SELECT
    ThisIsMyFirstCol = a.Col1
    , SecondCol = a.Col2
    , AndTheThrid = a.Col3
    , ForthCol = b.Col1
    , FithCol = CASE WHEN a.col1 = b.col2 THEN 'A'
    WHEN a.col2 = b.col3 THEN 'B' END

    FROM dbo.tableA AS a
    
        INNER JOIN dbo.tableB AS b
            ON a.Col1 = b.Col1
    
    12 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)
  6. When using the menu option "script object as..."
    1) when creating the new file have the name of the object be the filename. That way it is much easier to find in the tabs of SSMS instead of just another SQLqueryxx.sql file. This would make it much easier to find it again after switching away from that document.

    2) have some option setup to make it always be a create and not an alter. When I use the command its so I can see what the object is, I don't want to accidentally modify it so create means sql server…

    12 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. in the ssms object explorer, many of us regularly right click on tables to select top 1000 rows, which opens a new query window with an editable query script. visual studio's sql object explorer has no such functionality besides view data which forces you into a designer-based edit mode.

    11 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)
  8. Currently there is an option in the Code Formatter to word wrap code if it exceeds the right column margin, but that isn't ideal for the instance where you want an individual clause in the WHERE statement to stay on a single line no matter how long they are (makes it clearer what the exact logic is). Disabling this, though, forces all of the columns in the SELECT list to be on one line (I have stacking disabled for the fields). I'd say it is a common enough convention to warrant a special flag just for word-wrapping the columns in…

    11 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  ·  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. 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.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  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)
  10. Thank you for implementing enhancements to the document sessions. It looks great and adds much more value. I would like to suggest couple more enhancements:

    1. It would be more convenient if more recent sessions would be on the top instead of the bottom
    2. Apply connection coloring to the document sessions. So each file name would have a background color of the connection. It would make the 2 features integrated and extremely useful.
    3. Have a setting to remove old sessions older than 2 months (or period specified by users)
    4. Fix Display connection details next to each file (as you do in…
    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  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. 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)
  12. When I type group by and press the space bar to display "all non-aggregated columns" in the context menu. When I select this option, all columns that are not aggregated are added to the group with all their functions

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  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)
  13. Permitir comparar dos archivos o más objetos por selección; de bases de datos diferentes o de servidores diferentes.

    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  ·  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. We have a team of people and we'd like them to have one set of settings and snippets rather than having to keep multiple up to date.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. For ranking functions, the order by clause should not be formatted the same are the order by in a select.

    sample:
    Select
    [RowNumber] = RowNumber() Over (Order By o.[Order ID]
    , o.[Sort Order]
    , o.[Entry No])

    8 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  ·  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. When a single quote is entered, add a trailing quote and prefix the leading quote with an N if equality with a Unicode value can be inferred. Move insertion point between the quotes.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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)
    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)
  18. Add formatting options specific to Window Functions (e.g. ROW_NUMBER) for line breaks and spacing on the different arguments part of the function PARTITION BY, ROW, ORDER BY etc.

    7 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. You already provide an option to align column aliases in a select statement by a table view option in the stack list.

    how about alignment for tables aliases in a JOIN statement

    e.g.

    SELECT *
    FROM dbo.table1 t1
    JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
    JOIN dbo.table t ON (t.c1 = tx2.c2)

    /*****************************
    ** To This
    ** using _ to simulate spaces
    /*****************************/

    SELECT *
    FROM
    ____dbo.table1 _t1
    JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
    JOIN dbo.table _
    _t _ON (t.c1 = tx2.c2)

    7 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)
  20. Automatically propose join tables when JOIN instruction is typed.
    Proposal should not be baseed on existing tables relationships since most ERP out there do not have such relationships within the database.

    What I would like is that the user can configure all joins he knows for each tables and when the user types a SELECT instruction with JOIN that SQL Complete propose the list of all preconfigured joins for the tables already part of the SELECT.

    Ex:
    SELECT fields
    FROM Table1
    INNER JOIN Table2 ON Table1Key=Table2.Key
    INNER JOIN <here SQL Complete> would propose all preconfigured joins for Table1 AND Table2

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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?