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. Format the statements with table view

    DECLARE
    @tbl_VentasDetail TABLE (
    Id int,
    VentaDetailID int,
    VentaID int,
    EmpresaID int,
    PuntoVentaID int,
    ProductoID int,
    VentaDetailLinea int,
    VentaDetailConcepto nvarchar(50),
    VentaDetailCantidad decimal(18, 2),
    VentaDetailPrecio decimal(18, 2),
    VentaDetailCosto decimal(18, 2),
    VentaDetailBaseImpuesto decimal(18, 2),
    VentaDetailDescuento decimal(5, 2),
    VentaDetailImpuesto decimal(5, 2)
    )

    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 →
  2. 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 →
  3. When suggesting keywords place more relevant to this context to the top of the list.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  4. it could be usefull an utility to import/export the options configured by the user.

    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  ·  Admin →
  5. Place comma before a parameter item when you write a stored procedure or function

    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  ·  Admin →
  6. SQL 2008 intellisense also show parameters, this software no (at least the free version); it would be nice to have 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  ·  1 comment  ·  Admin →
  7. 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 →
  8. When using WHERE clause in select or update query, columns name don't appear even if alias.ColumnName is used e.g.

    SELECT
    *
    FROM
    Table t1
    WHERE
    t1.? (Columns should appear here)

    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  ·  Admin →
  9. Auto select the first suggestion by default, and I don't need to click or select it, 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…)
  10. Sql Complete should format 'if' and 'begin' 'end' like

    DECLARE @a as int
    SET @a = 1

    if (@a=1)

    begin

    print('a')

    end

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

    This functionality is already implemented in the product. If you have problems with it, please contact technical support.

  11. Currently, aliases are placed directly after the column name. Would like to be able to align them and see all aliases in the same column start position

    SELECT
    , FirstName + ' ' + LastName PurchasedBy
    , BranchName BName
    , DamageTotal Damage
    , PurchasePrice - WBACValuation AdjAmount

    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  ·  Admin →
    • After where or any other keyword, add a space
    • If there is a list of suggestions (ex. for a field name, user should be able to select the last item by the down arrow)
    • When one bracket is put, complete the other bracket and bring the cursor point to the middle
    • The same suggestion as above for the Begin - End (Also the Begin isn't auto complete)

    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  ·  Admin →
  12. Allow option to not fancy indent declared variables, but just put a new line after declare, and have all variables just indented with a tab (normally).

    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  ·  Admin →
  13. Make it ignore the DDL part and just format the actual view definition

    ALTER VIEW v_xyz AS
    SELECT
    .. some complex query

    GO

    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  ·  Admin →
  14. WITH Dates
    AS (SELECT DISTINCT test
    FROM test
    )
    SELECT *
    FROM Dates

    where I am expecting it to look like this:

    WITH Dates
    AS (
    SELECT DISTINCT test
    FROM test
    )
    SELECT *
    FROM Dates

    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  ·  Admin →
  15. A) connection identification
    a.1. paint background on crc24 of @@servername\db_name() with alfha at 15-20%
    a.2. allow a logo on right-bottom from local file or table.field of current connection

    B) if I have mySAP's 18.000 objects....
    b.1. allow completition ondemand on key (TAB) with rotation searching:
    objs: tblarc1, tblarc2, ...
    select * from arc{1°TAB} -> tblarc1 {2°TAB} -> tblarc2
    (can rotate or use SHIFT+TAB to go back)
    b.2 show tooltip with complete list of fields when mouseon obj/sp/fn/etc. identifier (of course the info gathering come from a separated thread or stop if mouse exit from tooltip area)

    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  ·  4 comments  ·  Admin →
  16. Everyone has their own preferences for formatting, which is why I think the number of options you provide for the formatting is really impressive. I think, however, that people likely tend to fall in to camps when it comes to their preferred formatting, so it might be helpful to determine the common configurations of the formatter, and then provide a handful of presets for the user to try out (with a preview of how various queries would be formatted). They could then go through and find whichever preset most closely matches their style, and then tweak it from there. Should…

    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  ·  Admin →
  17. This would likely have to wait until the live preview is implemented http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1434717-a-handy-feature-would-be-to-show-a-live-preview-of

    It would be awesome if there was a way with the live preview for the UI to indicate which options affected a given line. So, for instance, you click on one of the conditions in the WHERE clause, and it indicates that the 'New Line Before', 'Indent Clauses', and 'Word Wrap' options all contributed to how this line looks. That way if, for instance, the formatter is placing the 'AND' statement after the condition rather than before as you would prefer, the many options would be filtered…

    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  ·  Admin →
  18. I like Formatting source code, but for some keywords it not work fine me and make me irritate. The Following are the suggestion regarding Auto Formatting of Code on K, D in SQL.
    1. in current build on press on Ctrl + K,D all variable name become lower case. We are using camel / pascal notation in our DB. and when we press auto format key, it change all our table / view / column etc names. It remove pascal / camel notation.
    2. Ctrl + K,D does not format IF and UNION keyword. It should be like it is…

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

    > 1. in current build on press on Ctrl + K,D all variable name become lower case. We are using camel / pascal notation in our DB. and when we press auto format key, it change all our table / view / column etc names. It remove pascal / camel notation.

    You were using an old version of the product. Please upgrade dbForge SQL Complete to the latest version 4.0.55 where the issue is fixed: http://www.devart.com/dbforge/sql/sqlcomplete/download.html

    Please note that you can setup dbForge SQL Complete as follows:

    1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Formatting → Profiles’ branch.
    3. Select a profile.
    4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
    5. Select the ‘Text Case → Identifier Case’ branch.
    6. Select one of the options.

    > 2. Ctrl + K,D does not format IF and UNION keyword.…

  19. when i want tu format if else if block i want to get someting like this :
    if (1 = 1)
    begin
    set @avgweight = (select
    AVG(Weight)
    from Production.Product);
    end else if (1 = 1)
    begin
    set @avgweight = (select
    AVG(Weight)
    from Production.Product);
    end else if (1 = 1)
    begin
    set @avgweight = (select
    AVG(Weight)
    from Production.Product);
    end

    But best what i can do is this stacking indent behavior:

    if (1 = 1)
    begin
    set @avgweight = (select
    AVG(Weight)
    from Production.Product);
    end else

    if (1 = 1)
    begin
        set @avgweight = (select
            AVG(Weight)
        from Production.Product);
    end else
    
        if (1 =
    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  ·  Admin →
  • Don't see your idea?