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. Allow to specify code blocks that should be indented

    For Example:

    begin try
    {indented code}
    end try
    begin catch
    {indented code}
    end catch

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    This feature has already been implemented. But it’s available only in Standard edition of SQL Complete.
    Free edition has restricted formatting options.

  2. Show the table columns in the Intellisense when you create temp tables or declare table variables.

    29 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 →
  3. When there's a valid sql object under the cursor in the text editor, two nice features (via context menu):

    1. Go to definition (select in object explorer)
    2. Script object (clipboard, new window, etc...)

    Also object names should be shown as a link if the Ctrl key in pressed. All object names in script shows as hyperlink. Ctrl+click or Ctrl+Enter on it opens the object definition in new tab.

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  4. 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)
    You have left! (?) (thinking…)
  5. 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 →
  6. 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 →
  7. When selecting the various code formatting options it would be very useful to be able to see the effect in real time of the selections on a sample piece of code. Having to make selections, then close the options and Format the code, then go back and tweak is a bit of a pain.

    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  ·  0 comments  ·  Admin →
  8. qualify names in a sentence, ussing alias (if present) or table name

    2 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 →
  9. Two ideas here:
    1. Limit the suggestion list (entry in options dialog - "Max count suggestions"
    2. Loading details could be async

    3 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 →
  10. If I enter ...
    select replace(
    and then I type ctrl-space (ie. give me the params available) Server Studio hangs.

    4 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 →
  11. 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…)
  12. 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…)
  13. Highlight all occurrences of a selected word in the current document.

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  14. For example:

    SELECT Col1
    , Col2
    , Col3

    etc.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  15. Right alignment of keywords is an important formatting option.

    25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  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…)
    completed  ·  1 comment  ·  Admin →
  17. 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)
    You have left! (?) (thinking…)
  18. When you paste a large query containing lots of UNION statements, SQLComplete consumes all available CPU (one logical cpu only) and RAM and SSMS has to be killed to recover. I can email a sample query if required.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  19. 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…)
  20. 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)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
  • Don't see your idea?