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. When autocompleting a parameter less function like say: getdate, include also the braces () and put the caret after the closing brace so you can continue typing without having to type the braces youself

    When autocompleting a function with parameters, also automatically put the braces, but place the caret in between the braces (<caret here>) so you can directly start typing the parameter.

    16 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  ·  Admin →
  2. We have a SQL environment that includes several linked servers and sometimes writing a quick investigative query to one of them is more conveniently done from the current context, rather than opening a new connection in SSMS. Some of my coworkers use Redgate's SQL Prompt which offers auto-completion for linked servers and I would like to see that functionality available in SQL Complete

    15 votes
    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 →
  3. 15 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 →
  4. To differentiate the 'Keyword case' formatting setting for keyword commands like SELECT, FROM, LIKE and WHERE and data types like int, varchar and money.

    15 votes
    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 →
  5. Option to place table name after JOIN on a new line

    ...
    FROM
    TABLEA
    INNER JOIN
    TABLE
    B
    ON .......

    14 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  ·  Admin →
  6. On our severs we have large number of databases with same structure and use SQLCMD variables for databaseand shema name in our scripts. Example select t1.* from $(databasename).$(shemaname).TABLE1 t1. It would be very usefull to have intellisence enabled if I type "t1."

    14 votes
    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 →
  7. The keyboard shortcut to run Execute statement in query editor is F5. If we have multiple queries in the same query editor window, all the query will be executed, unless we first highlight the part of query that we want to execute, and then pressing F5.

    I'm suggesting that instead of selecting the statement (usually by using a mouse movement) and pressing F5, we can just put the cursor anywhere in the statement that we want to run, and then pressing keyboard shortcut (something like ctrl+F5) will run the "current statement" which is the text between the first "newline +…

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  8. When you type "insert into mytable(", the autocomplete list should contain for example a star character on top, which adds all columns of the given table. So there's no need to select every column separately.

    It would also make sense in select statements, when the alias is known.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  9. 13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  6 comments  ·  Admin →
  10. Display more information about Document Sessions. Currently, it just has SSMS version and number of files in the session (SSMS 2017 (2)).

    Session Caption:
    1. SSMS Version is close to useless. Because SSMS 2017 provide great backward compatibility with other SQL Server versions. So you don't really need. Please remove it.
    2. Add date and time when the session was saved last time.

    File list:
    3. It would be useful to have server and database next file name.
    4. Each file has backup time but not backup date. Please add it.

    Document Sessions screen:
    5. Revisit design of the Document…

    12 votes
    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  ·  Features  ·  Admin →
  11. When using a table alias of "u", all new instances becoming capitalized incorrectly.

    Please see attached gif:
    https://ibb.co/fr9LcH

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  8 comments  ·  Admin →
  12. You have a very convenient feature Highlight Occurences to highlight all field or variable occurrences.

    I would suggest you to make a highlighting of the corresponding value in the INSERT SELECT construction when navigating to a field.

    In the following example, when navigating to the 3rd column, the corresponding value should be highlighted in the SELECT clause too:

    INSERT INTO table (clm1, clm2, clm3, clm4, clm5)
    SELECT 0, 1, 5, 0, 3

    11 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  ·  Admin →
  13. SSMS Tools Pack has a feature where you can right click on the results pane and click 'Search Grid Results'. Then you can enter some text and it'll find data in the results that match your search term. This is VERY handy.

    11 votes
    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. Can database schema be included (optionally) in the intellisense object name selection? e.g. [dbo].[tablename] ?
    (the square brackets also being optional)

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  15. 11 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  ·  Admin →
  16. 11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  17. Intellisense & Formating is not working in Stored Procedures

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. 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 →
  19. 10 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  ·  Admin →
  20. Would be great to be able to highlight multiple cells in the Results grid and then select "Copy as SQL values List". This would then create a single line, comma-separated list which could, for example, be pasted into a WHERE in () clause.

    Functionality must be able to detect whether you're copying integer or character values etc. If copying character values, SQL Complete should automatically enclose each value with single quotes

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