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

310 results found

  1. It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.

    6 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)
  2. When joining tables I often get suggestions by SQL Complete for which tables to join. This is extremely useful and saves me a lot of time. Often times however there are multiple joins I want to make to different tables. But I can only select one join at a time. Selecting multiple suggestions with a ctrl+left click or something similar in the suggestions box would be a great addition for my workflow.

    3 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)
  3. 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…)
    planned  ·  5 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)
  4. 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)
  5. There should be a global empty line management structure for formatting. It would be nice to see:

    - Add empty line before/after keyword
    - Remove empty lines
    - Add empty line between statements
    
    17 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)
  6. The tooltip font is just too small ...

    4 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)
  7. 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)
  8. In a SQL script, I create several schemas, tables, and procedures. I'd like to have the ability to right-click an object name (in the editor), and select something like "Generate DROP IF EXIST".

    The tool would understand the object type and automatically add the following to the top of the file:

    DROP PROCEDURE IF EXISTS <SchemaName1.ProcName1>
    DROP PROCEDURE IF EXISTS <SchemaName2.ProcName2>
    DROP TABLE IF EXISTS <SchemaName1.TableName1>
    DROP TABLE IF EXISTS <SchemaName2.TableName2>
    GO
    DROP SCHEMA IF EXISTS <SchemaName1>
    DROP SCHEMA IF EXISTS <SchemaName2>

    13 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)
  9. Offer refactor option that fully qualifies object names with schema. I know the option is there to do this when typing, ensuring aliased/qualified names. However, one feature in SQL Prompt from RG that is pretty amazing is the option to "refactor-qualify", and it will parse all the object schema names and ensure your proc/table/view/etc calls have the schema name in front of them. This is considered a good practice, but doing manually is very time intensive.

    16 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)
  10. Add an option to format JSON output with proper indentation and line feeds

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. No option to enlarge font. font size on intellisense is too small.

    3 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)
  12. There may be times when you would like to switch the formatting for a particular section of code because the global settings would not be most appropriate.

    For example let's stay in SELECT statements you have "Stack Columns" checked with "Simple List" selected. This may be the desired format for 90% of the cases, however when there is a table with a large number of columns(50+), it could be more beneficial to view them on a single line so to see the query as a whole.

    If you could add a comment before the query
    --@Begin-SQLComplete Select-SelectList-StackColumns = True; Select-SelectList-StackColumns-Option=SingleLine…

    4 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)
  13. The ability to add folders in SSMS for database objects. I understand these folders would only be virtual.

    I know of one addin that has this feature. www.sqltreeo.com

    43 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)
  14. Microsoft's SQL Server Management Studio puts square brackets [ and ] around everything scripted or dragged/dropped from the Object Explorer to the scripting window.

    I want a feature to remove all square brackets.

    I currently have to use SQL Management Studio search/replace to remove the brackets, and rather have the removal performed when I format the code.

    Jake

    73 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 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)
  15. 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)
  16. For example, let's assume this is the output from a query:

    id name role

    1 Torn ADMIN
    2 John CLERK
    3 Adam SUPER

    I would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.

    In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
    name = 'Adam' and role = 'SUPER'

    16 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)
  17. A popup that list recently used/pinned servers-database
    allowing for 1-click switch to that database while writing your query.
    A shortcut key for this would be appreciated.

    The Current default SSMS behaviour > Select a server then select a database then continue working. sometimes ones default database is set to master/orsomedb which is inconveinient and always has to switch.

    19 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)
  18. PLEASE, allow user to change the keybinding for 'Execute Current Statement' , this should not be that difficult. Believe it or not, I have to move my hands on the keyboard quite a bit to type 'Ctl-Shift-E' .

    If you can't open it up for a custom key binding , then at least give some options , like ' Alt-E ' would be very nice.

    Related to this feature:
    http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1335977-add-a-feature-to-run-current-statement

    25 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)
  19. In my database named "IDS", I have a schema named "ids".
    I would like to specify that the schema be lower case when formatting.

    This is what currently happens.
    When I format something like this:
    select * from IDS.ids.Location l;

    It is formatted to:
    SELECT * FROM IDS.IDS.Location l;

    I would like to specify that the schema be lower case:
    SELECT * FROM IDS.ids.Location l;

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Currently SQL Complete notification (like "Uncommitted transaction" and "Query execution completed") show up and disappear. It would be great to have them on a panel similar to "Document Sessions", so you can review them later.

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