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

  2. 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 →

  3. Status bar color (use the tab color)

    I would like to see the status bar colored like the tab. The tab coloring is already implemented so it would be nice to sync with the status bar also.

    1 vote
    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 →

  4. 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 →

  5. Increase thickness of the window coloring line

    Please add an option to control the thickness of the coloring line of the tab for different servers. The line on the top of the screen is very thin on high definition monitors, so it is difficult to see.

    1 vote
    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  ·  4 comments  ·  Admin →

  6. Code formatting for Merge Into "Values"

    Merge doesn't have formatting for source table formed from values.

    MERGE INTO [TargetTable] AS T USING (
    VALUES (@UserId, @InternalId)) AS S
    ([UserId], [InternalId])
    ON T.[UserId] = S.[UserId]
    WHEN MATCHED ...

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

  7. Display more information about Document Sessions

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  8. 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 →

  9. Support for multiple SSMS instances

    When running two or more SSMS instances there is an error that pops up pretty often saying: "Access to the path 'C:\Users\FFlintstone\AppData\Roaming\Devart\dbForge SQL Complete\docsessions-journal.db' is denied."

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

  10. Automatically add terminating semi-colons to statements

    Given that MS is going the route of eventually requiring terminating semi-colons on statements, it would be useful to have an option to do that for me.

    1 vote
    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

    With dbForge SQL Complete v5.6.146, you can right-click in the SQL document and select ‘Insert Semicolons’ from the popup menu.

  11. Options group for logical operation enclosed in braces

    Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:

    Line break before opening brace
    Line break after opening brace
    Line break before closing brace
    Line break after closing brace
    Indent braces
    Indent logical operation
    Format braces around single comparison operation as in logical operations

    Also, make the same options group for the following predicates:
    - EXISTS
    - ALL
    - ANY
    - SOME

    For details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030

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

  12. Close SQL Complete connection to SQL Server when not being used.

    When running sp_who2 I can see tasks for "dbForge SQL Complete" for each user running SSMS even when it's not doing anything. (I guess the connection is pooled between each request that the application needs to make?)

    Anyway, our admins don't like to see all of these jobs just hanging around doing nothing, especially on our live servers. Any chance of turning off your connection pooling?

    1 vote
    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 →

  13. add a shortcut to do a "edit top 200 rows" on a selected SQL sql statement

    Add a shortcut in the context menu to do a "edit top 200 rows" on a selected SQL sql statement

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

  14. 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 →

  15. 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 →

  16. separate options for text case for tables and columns

    I like to have separate options for setting the text case for table aliases and for column aliases.
    Personally I want my table aliases to be in lower case and my column aliases not changed (or starting with initial caps, depending on the project I'm working on).

    1 vote
    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. mouse over

    On mouse over column or variable, show datatype full . Ex: varchar(nn), bigint NOT NULL primary autoincrement has index has unique has clustered...

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

  18. Built-in DataType Case option is being ignored

    In SQLComplete 5.5.159, the Built-in DataType Case set to lower, but all types are automatically converted to upper case

    1 vote
    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  ·  Bugs  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    This can be setup as follows:
    1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Formatting → Profiles’ branch.
    3. Select the active profile.
    4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
    5. Navigate to the ‘Text Case’ node and select the options you need.

  19. Active Directory Integrated Authentication

    We'd like SQL Complete to work with (Azure) Active Directory Integrated Authentication

    18 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. 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 →
1 3 5 … 13 14
  • Don't see your idea?