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.

275 results found

  1. List members for XML type

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

  2. Support for ANSI-quoted identifiers

    For example
    SELECT * FROM "Person" WHERE "Person".

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

  3. Intellisence on cross database queries

    Show database objects when writing cross database queries.
    SELECT t.*
    FROM [dbName].[dbo].[table] t

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

  4. Shortcuts for common queries like SELECT * FROM

    I saw another program that allowed shortcuts such as typing ssf generated query "SELECT * FROM"
    I could create new shortcuts too. See this for details: http://www.ssmstoolspack.com/

    0 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  ·  3 comments  ·  Admin →

  5. xml Data Type methods

    The xml Data Type methods (http://msdn.microsoft.com/en-us/library/ms190798.aspx) MUST be lower case. We have keywords set to be upper case, and that makes the xml Data Type methods upper case too, which does not work.

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

  6. Once ON is typed put the name of the current procedure at the top of the suggestion list

    When creating a procedure, often the next step is to execute a piece of permission code. ie:

    CREATE PROCEDURE db.uspdbForgeSQLComplete
    GO
    GRANT EXECUTE ON ..... TO .....
    GO

    Once ON is typed it would be great if the prompts list included the name of the current procedure at the top of the list even if it hasn't yet hit that cache or been created.

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

  7. Option for Line break between tables in join

    Multiple tables in the join statement are indented correctly, but no option to add a line break between the table joins. I find this line break to help legibility when dealing with many tables in a join.

    I think adding the option "break before JOIN keyword" would solve that issue, and not require evaluating for subquery or further complex on statement conditions.

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

  8. Have column selector available on insert statements

    0 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. Wrap string concatenation

    Have the option to set max length for concatenation string. I've seen this implemented in SQL Beautifier and it helped legibility on long strings.

    User should be able to choose max length of characters before wrapping begins, then wrapping begins with + at beginning of line.

    It changes string from long string that user must scroll or have word wrap affect.

    BEFORE:
    ,comment_string = 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text'

    to:

    ,comment_string = 'Sample text' + 'Sample text'
    + 'Sample text' + 'Sample text'
    + 'Sample text'

    This would be great to…

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

  10. Subquery indentation aligned with paranthesis

    Requesting a tweak to the indentation level settings for subqueries.

    If I have it set to have closing parenthesis on a new line, I'd like the option to align the whole thing with the starting parenthesis, and this to be the alignment point of the subquery. Increases legibility when lots of subqueries are involved.

    Targeted format:
    select
    1
    ,2
    ,3
    from
    table11 t

    inner join table2 t2
on t.value = t2.value

inner join ( -- starting parenthesis

            select
                1
                ,2
                ,3
            from 
                subquerytable3
            where
                test = test
            ) f on t.value = v.value
                and t.value2 = v.value2

    where
    test =…

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

  11. Datepart parameter inside DATEDIFF function adds parentheses

    When using the DATEDIFF function for example, the first parameter is a datepart (year, month, day, etc). The code completion for that parameter always adds parentheses after the datepart - e.g. DATEDIFF(YEAR(), Start, End). Is it possible to turn off the addition of the parentheses to the datepart inside a function that has datepart as a parameter?

    0 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. Initial caps each word option for aliases

    Add the 'Initial caps each word' option to the 'Text Case -> Identifier Case' branch in formatting profiles.

    0 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. Ability to wrap parameters

    Most of the time I prefer parameters on a single line, but in case they are many I like to wrap.. perhaps two or three in each line.

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

  14. Ability to align opening braces in INSERT

    For insert I would like the starting brackets of fields and values to be aligned.

    The formatter produces

    insert into Table (Field1, Field2)
    values (1, ‚text‘);

    when ideally I would like

    insert into Table (Field1, Field2)
    values (1, ‚text‘);

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

  15. Suggest object by capital letter abbreviation. Similar to ReSharper

    When typing in a statement. For example:

    SELECT *
    FROM MyTable

    Instead of having to type in MyTable. I would just like to enter

    SELECT *
    FROM MT

    At which point the suggestion box would identify the table MyTable based on it's initial capital letter at the beginning of each word.

    Similar to the feature in ReSharper:

    https://www.jetbrains.com/resharper/webhelp80/Navigation_and_Search__CamelHumps.html

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

    Please perform the following:

    1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
    3. Select the ‘Camel Case’ option.
    4. Click ‘OK’.

1 2 … 10 11 12 14 Next →
  • Don't see your idea?