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

  2. sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query (or vice versa), taking into account t

    Sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query, taking into account the column aliases. Thus

    INSERT INTO table
    (columnA, columnB, columnC)

    SELECT foo AS columnB, columnC, bar AS columnA
    FROM table2

    becomes
    INSERT INTO table
    (columnB, columnC, columnA)

    SELECT foo AS columnB, columnC, bar AS columnA
    FROM table2

    With a few columns it's no big deal to do it manually but with 20 columns it is.
    Displaying a hint if columns are missing is also welcome.

    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 →

  3. 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’.

  4. I can't give a custom format to a clausule UNION

    I can't give a custom format to a clausule UNION

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

    This can be setup in the ‘UNION’/EXCEPT/INTERSECT’ section of the ‘Edit Formatting Profile’ window.

    To open the ‘Edit Formatting Profile’ window, please perform the following:
    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 and click the ‘Edit Profile…’ button.

  5. cte

    It looks like the execute current statement command can't deal with CTEs which is a bit annoying. Overall this is great though, makes using SSMS much better.

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

  6. intellisnese for temp tables

    I was ready to buy but intellisnese on temp tables is a must

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

  7. Should have provision to configure Query Alignment

    Should have provision to configure Query Format
    like (Each column to be placed in separate Line,
    Join condition in single Line,
    etc.)
    or
    Indenting is missing in formating

    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 →

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

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

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

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

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

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

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

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

  17. Make the output of Script As go to the clipboard as an option

    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 →

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

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

  20. Disable Data Loss warning for a specific Script

    I love the new feature that warns before delete data without any where.

    However when writing migration scripts and debug them it can be annoying because it pops up every time.

    would be nice if this could be disabled for a script.

    for example by using a comment like --disable warning--

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