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. Option to put commas at beginning of line rather than end - Revisit in 3.5.61

    This was closed, but seems to be missing from version 3.5.61

    Option to put commas at beginning of line rather than end
    http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1325453-option-to-put-commas-at-beginning-of-line-rather-t

    For example:

    SELECT Col1
    , Col2
    , Col3

    etc.

    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…)
    declined  ·  4 comments  ·  Admin →

  2. format: db Identifier case issue,it does not work for similarly named columns

    When you format text based on
    Text Case > Identifier Case > As in database
    It does not work as expected.
    e.g. supposedly i have some tables definitions

    CREATE TABLE DUCK1(Abc int)
    CREATE TABLE DUCK2(aBc int)

    CREATE TABLE DUCK3(abC int)

    I these are the statements i want to format

    select d.abc from duck2 as d
    select d.abc FROM duck3 as d

    but what i get after formatting is this

    SELECT d.aBc FROM DUCK2 AS d
    SELECT d.aBc FROM DUCK3 AS d

    this is not what was expected.

    4 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  ·  Bugs  ·  Admin →
    declined  ·  AdminDevart (_, Devart) responded

    In case there are multiple objects with different case in the database, dbForge remembers the case of the first found identifier in the database and uses it for all identifiers with this name.

  3. mark statement to exclude in execution history

    Possibility to exclude lines of code in execution history that include senitive date (username and/or password)
    example:
    -- run code in sqlcmd mode
    :connect [servername] -U my_account -P T0pS3cretP@ssw0rd!

    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…)
    declined  ·  1 comment  ·  Features  ·  Admin →

  4. dbForge keep the database in use even you execute an explicit use master

    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…)
    declined  ·  0 comments  ·  Admin →

  5. Custom SQL file extensions.

    All of our SQL scripts are in TFS so I tend to open them in Visual Studio, edit them there, and check'em back in. However, where I work, each "script type" has a different extension (not ".sql"). For example, a procedure script would be ".prc", table ".tab", view ".viw" etc... I'm not necessary in agreement with these naming conventions, but I have to deal with them nevertheless. The problem relating to SQL Complete is that these extension types are not recognized so I get none of those juicy features we all love. The only way around it is to change…

    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 →

  6. Highlight matching parenthesis in editor

    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 →

  7. table alies prefix in pivot wrong

    When using PIVOT the columns are prefixed with the table alias of the table inside of the pivot and nog with the alias of the pivot

    2 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…)
    declined  ·  0 comments  ·  Bugs  ·  Admin →

  8. Make the intellisense work - redgate's products work

    New and outrages functionality

    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…)
    declined  ·  0 comments  ·  Admin →

  9. Alias casing variation between columns and table Alias

    When creating a formatting profile there is only one selection for Alias casing, in my personal experience my column alias casing differs from my table alias.

    EX:

    Select
    det.name AS UserName
    , det.id AS UserId
    , det.phone AS UserPhone
    , det.description AS UserBio
    FROM dbo.exampletable det

    when running through my formaterr with the setting Alias Case set to 'Lower' it changes my column alias's whether they are snake_Case PascalCase to lower

    TLDR : have a setting to alter column alias case individually rather than a global alias case 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…)
    declined  ·  1 comment  ·  Features  ·  Admin →

  10. Suggest joins for columns from cross/outer apply

    When doing a join on a table to a cross/outer apply function, intellisense doesn't suggest any joins based on column names like it does for joins on tables/views

    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…)
    declined  ·  1 comment  ·  Bugs  ·  Admin →

  11. Add ability deleting formatting profiles

    The point 'Delete' is disable in the context menu in
    SQL Complete->Options->Formatting->Profiles

    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…)
    declined  ·  0 comments  ·  Bugs  ·  Admin →

  12. UPDATE statement expansion has "WHERE ID = DEFAULT" as the WHERE clause

    "WHERE ID = DEFAULT" is not a valid WHERE clause

    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…)
    declined  ·  0 comments  ·  Bugs  ·  Admin →

  13. not show user defined variable in option

    not show user defined variable in 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…)
    declined  ·  0 comments  ·  Admin →

  14. Prametirired Queries

    I want to be able to write parametirased queries like select * from table where id = @id. When i try to run that sql compare can ask me about values of the parameters.

    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…)
    declined  ·  0 comments  ·  Admin →

  15. Improve "Execute current statement"

    The current statement is not executed when it is commented out.

    If i have the following query and attempt to execute it, SSMS says "Command(s) completed successfully.". The query is not actually executed.
    -- select * from table1

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

  16. Ability to choose which SQL server to activate dbForge SQL Complete

    If I have to work with multiple versions of sql server, decide which server / version sql server enable auto-complete

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

  17. Show fields Binary (BLOB) in the result of a select

    When you run a SELECT query that contains a BLOB field would be nice to offer the option to display in Hexadecimal format, Image, Text, etc.. In addition to allow edit or delete them

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