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.

17 results found

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

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

  3. Execution History not saving data

    I have a problem with execution history, recently it stopped behaving correctly. So I daily use SSMS and connect to 2 local instances and several other azure instances. When I open the execution history I notices sometimes that I do not have a log for anything for the past 2 days, for example today is 9th of July, and "Execution History" has records for 7th of July.. 8th and 9th are not there.

    Also it is not recording all executions for all servers, so it might record only 1 for a server and several for another. I am not sure…

    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 →

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

  5. table function hint shows wrong parameters

    When selecting from a table function the tooltip shows the return columns along with the parameters at last, which is super confusing.

    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 →

  6. Bug in SQL Complete when using spatial functions

    I have a Problem with spatial functions when using SQL Complete.
    SSMS 18.12.1 always hangs when geompetry functions are used in query editor and SQL Code Completion is turned on.
    eg.: geometry::STPointFromText(( ...
    I have to kill ssms in Taskmanager to recover.

    Please fix this, otherwise SQL Complete is a great tool. SSMS feels broken without it.

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

  7. Keep the comments when formatting procedures!

    Keep the comments when formatting procedures! IT can't be that all comments are removed by the formatting process! That happens to my code when I execute ALTER PROCEDURE!
    OR: Give me the option to NOT format my code! I use the Express Version.

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

  8. Alias CTE like tables

    When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue

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

  9. Meaningful parameter names for system functions

    Example: suggestion for CAHRINDEX function should look like (expressionToFind , expressionToSearch) instead of (expression1, expression2)

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

  10. SQL XML fucntion value is changed to Value (uppercase V) when formatting a document. This is not valid SQL

    Formatting document should not change value to Value in an XML SQL query. Value is not a valid function

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

  11. checking update failed

    The checking update menu in sql complete may point to a HTTP url and currently devart.com is only available via HTTPS protocal. It let the update checking 100% failed with network error message: cannot connect to remote server.

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

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

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

  14. SQL Complete causes an permanently unresponsive UI in Visual Studio or Sql Server Management Studio when closed while retrieving metadata

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

  15. Fix erroneous formatting error when formatting DBCC show statistics

    When "Format Selection" operates on the following T-SQL code an error is generated.

    DBCC SHOWSTATISTICS(N'dbo.charge', _WASys000000060DAF0CB0)
    WITH DENSITY_VECTOR;

    The error:

    1. C:\Users\jhatt\Documents\SQL Server Management Studio\SQL Server Projects (all versions)\CommonQueryTuning\Part01Module_02\07 Density Vector with an unknown runtime value.sql: Error (22,12): 'Identifier' expected
    2. C:\Users\jhatt\Documents\SQL Server Management Studio\SQL Server Projects (all versions)\CommonQueryTuning\Part01Module_02\07 Density Vector with an unknown runtime value.sql: Error (20,13): ''as'' expected
    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  ·  Bugs  ·  Admin →

  16. Add functionality to refresh the connection from ssms, when it is lost or kill i must open a new instance of ssms to get functionality back

    Add functionality to refresh the connection from ssms, when it is lost or killed by my dba i must open a new instance of ssms to get functionality back

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

    In order to resolve this issue, please perform the following:

    1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘General’ branch.
    3. Unselect the ‘Enable SQL Complete’ option.
    4. Click ‘OK’.
    5. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
    6. Navigate to the ‘General’ branch.
    7. Select the ‘Enable SQL Complete’ option.
    8. Click ‘OK’.

  17. Declare Parameter in SP is not showing in List of Variables

    When we Create some SP with Parameters and when we are using those parameter in SP Coding then Those parameter name is not showing in List of Variables..

    Kindly solve this bug in new release...

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