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. Refactoring: Change variable name in procedure

    refactoring (change a variable name in a procedure for example, and have that change propagate throughout the procedure for each instance of the variable)

    3 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. Ability to change the keyboard shortcuts used in SQL Complete

    Add the ability to modify the keyboard shortcuts used for certain SQL Complete features. Reason for requesting this is due to the fact that certain keyboard shortcuts chosen by SQL Complete may clash with shortcuts used by other third party tools.

    In my case, the format selection shortcut, Ctrl+K, Ctrl+F is used in the SSMS Tools Pack add-in I have installed. So when I try to use Ctrl+K, Ctrl+F I get the SSMS Tools Pack resultant of the shortcut, and not the format selection option of SQL Complete.

    3 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…)
    2 comments  ·  Admin →

  3. Intellisense for table definition should use INFORMATION_SCHEMA data.

    It seems the current implementation parses a CREATE TABLE statement and only shows the columns defined there when you hover over a table name. Columns added later via ALTER TABLE statements do not show up. The intellisense list should be built by querying the CURRENT table structure via INFORMATION_SCHEMA.COLUMNS in order to show all columns.

    3 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…)
    2 comments  ·  Bugs  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    Please check that you have selected the ‘Automatically refresh suggestions cache’ and ‘Detect changes on a server before refreshing suggestions cache’ options in the ‘Text Editor → Code Completion → General’ section of the ‘Options’ dialog box that can be opened by selecting ‘Tools → Options’ from the main menu.

    Please also check that the altered object belongs to the database selected in the ‘Database’ drop-down menu on the ‘SQL’ toolbar.

  4. Restore position and visibility of the Document outline window when SSMS starts

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

  5. JOIN FIELDS SUGGESTIONS - Enable TAB acceptance of first suggestion

    When PRIMARY and FOREIGN KEYS share the SAME NAME according to best practises allow the JOIN suggestion to be immediatly pick up with TAB.
    Most of the times the good suggestion comes at top on the list and one can allways navigate to a better one if this is the case

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

    This can be achieved as follows:

    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 ‘Tab’ option.
    4. Click ‘OK’.

  6. Add extended properties for columns in quick info window for table

    When navigating the mouse cursor to a table, display extended properties in the quick info window.

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

  7. Support temp tables in Intellisense

    Make intellisense to cover the temporary table for example "#rs" ,"##table"

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

  8. Intellisense doesn't work when using CROSS/OUTER APPLY of a user defined table-valued function

    When filling in the parameters for the TVF and it has been CROSS/OUTER APPLY'd with a table, the intellisense does not show any of the fields from the table even though they are allowed in the TVF. Even if the parenthesis is closed on the TVF, the table's fields don't show up. The intellisense options that come up are the generic list of dbs, tables, functions, snippets, etc.

    E.g. -
    SELECT * FROM Users u
    CROSS APPLY dbo.FindInvoiceFiles([INTELLISENSE DOESN'T SHOW FIELDS FROM Users table]) fif

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

  9. Fully qualified server reference

    When performing a query like "Select * from Servername.schema.table"

    where servername is the current server connected to, table hints are not available.

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

  10. Add #temp support to the express addition

    Adding limited support for auto SQL complete for column names to be read from #temp table in the express version

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

  11. Fix capitalization for identifiers with underscores in them _

    I spend most of my time working in databases that (unfortunately) use _ underscores to separate words. For example, a table might be called VehicleRidershipActivity instead of VehicleRidershipActivity. This causes the "Proper Case" option to not work on any of these table names, column names, sproc names, etc..

    The worst part is that even if I type them correctly or paste them in when they were correct, they will get "corrected" to all lower-case letters after the first letter (for example VehicleRidershipActivity will be changed to Vehicleridershipactivity).

    If this is intended, please consider changing.…

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

  12. Synonyms Intellisense

    Please provide Code Completion for Synonyms!

    I have a development database where I created a synonym for every table and view in another database on another SQL server. When I use SQL Complete and type a SELECT statement for a synonym, column names do not appear.

    Please modify SQLComplete to provide column names when crafting a SQL statement for a synonym!

    Thanks!

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

  13. warn when running a query with no predicate

    if running an update/delete statement with no predicate on it, it would be nice if there was a warning to appear asking if I was sure I wanted to run the query.

    it would prevent accidental deletion/update of a full table when I was only after one row and I forgot to include the predicate.

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

  14. Functions on Result Window

    After selected a column in the result window the possibility of some funcions on it:
    - the min/max/avg of the column (if number)
    - order the results by a column A-Z, Z-A
    - filter the rows with a value
    - ...

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

  15. Add support for system stored procedures like sp_help

    SQL Complete stops giving any table suggestions following a system command like sphelp or sphelptext. It should recognize "sp_help Customers" as valid and intellisense should continue working for any statement written below.

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

  16. De-couple execute-current-statement functionality from code completion.

    I like execute-current-statement functionality, but when I disable code completion then execute-current-statement functionality stops working.

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

  17. Ability to select multiple fields from code completion( wildcard expansion)

    Could you please provide the ability to select multiple fields from code completion pop-up( wildcard expansion).

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

  18. CTR+F12 Options

    Currently in SSMS if you right click on a stored procedure and select modify you get something like this

    ALTER PROCEDURE [dbo].[ProcedureName]

    In SQL complete when use the key commands CTRL+F12 on exec ProcedureName you get this

    ALTER PROCEDURE dbo.ProcedureName

    notice the missing hard brackets.

    I would like an option i can set in SQL Complete to include the hard brackets

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

  19. Execution History by server

    Filter execution history by server that the code has been executed on.

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

  20. Select and copy from Execution History results

    Now it is possible copy all script from Execution History results (to clipboard or new window).
    But sometimes it is required to copy just part of the code.
    It is possible to select code in Execution History result window, but not possible to copy it.

    3 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 →
1 2 … 6 8 10 … 13 14
  • Don't see your idea?