280 results found

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Features  ·  Delete…  ·  Admin →
   completed  ·  AdminDevart (_, Devart) responded

   This feature is implemented in v5.8 excepting:
   - order the results by a column A-Z, Z-A

   We added a separate suggestion for this https://devart.uservoice.com/forums/87893-sql-complete/suggestions/33150733-order-the-results-by-a-column-a-z-z-a-in-result-w

2. Initial caps each word option for aliases

   Add the 'Initial caps each word' option to the 'Text Case -> Identifier Case' branch in formatting profiles.

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  1 comment  ·  Edit…  ·  Delete…  ·  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 Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Bugs  ·  Delete…  ·  Admin →
   completed  ·  AdminDevart (_, Devart) responded

   This issue is fixed in dbForge SQL Complete, v5.6.169 https://www.devart.com/dbforge/sql/sqlcomplete/download.html

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Features  ·  Delete…  ·  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.

8. Subquery indentation aligned with paranthesis

   Requesting a tweak to the indentation level settings for subqueries.

   If I have it set to have closing parenthesis on a new line, I'd like the option to align the whole thing with the starting parenthesis, and this to be the alignment point of the subquery. Increases legibility when lots of subqueries are involved.

   Targeted format:
   select
   1
   ,2
   ,3
   from
   table11 t

   inner join table2 t2
   on t.value = t2.value
   
   inner join ( -- starting parenthesis
   
               select
                   1
                   ,2
                   ,3
               from 
                   subquerytable3
               where
                   test = test
               ) f on t.value = v.value
                   and t.value2 = v.value2
   

   where
   test = test

   CURRENT FORMAT ALIGNS TO THE KEYWORD ONLY, not parenthesis.
   select
   1
   ,2
   ,3
   from
   table11 t

   inner join table2 t2
   on t.value = t2.value
   
   inner join ( -- starting parenthesis
   
   select
       1
       ,2
       ,3
   from 
       subquerytable3
   where
       test = test
   ) f on t.value = v.value
       and t.value2 = v.value2
   

   where
   test = test

   Requesting a tweak to the indentation level settings for subqueries.

   If I have it set to have closing parenthesis on a new line, I'd like the option to align the whole thing with the starting parenthesis, and this to be the alignment point of the subquery. Increases legibility when lots of subqueries are involved.

   Targeted format:
   select
   1
   ,2
   ,3
   from
   table11 t

   inner join table2 t2
   on t.value = t2.value
   
   inner join ( -- starting parenthesis
   
               select
                   1
                   ,2
                   ,3
               from 
                   subquerytable3
               where
                   test = test
               ) f on t.value = v.value
                   and t.value2 = v.value2
   

   where
   test =… more

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Delete…  ·  Admin →

9. Wrap string concatenation

   Have the option to set max length for concatenation string. I've seen this implemented in SQL Beautifier and it helped legibility on long strings.

   User should be able to choose max length of characters before wrapping begins, then wrapping begins with + at beginning of line.

   It changes string from long string that user must scroll or have word wrap affect.

   BEFORE:
   ,comment_string = 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text'

   to:

   ,comment_string = 'Sample text' + 'Sample text'
   + 'Sample text' + 'Sample text'
   + 'Sample text'

   This would be great to have!

   Have the option to set max length for concatenation string. I've seen this implemented in SQL Beautifier and it helped legibility on long strings.

   User should be able to choose max length of characters before wrapping begins, then wrapping begins with + at beginning of line.

   It changes string from long string that user must scroll or have word wrap affect.

   BEFORE:
   ,comment_string = 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text'

   to:

   ,comment_string = 'Sample text' + 'Sample text'
   + 'Sample text' + 'Sample text'
   + 'Sample text'

   This would be great to… more

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   completed  ·  2 comments  ·  Delete…  ·  Admin →

10. Option for Line break between tables in join

    Multiple tables in the join statement are indented correctly, but no option to add a line break between the table joins. I find this line break to help legibility when dealing with many tables in a join.

    I think adding the option "break before JOIN keyword" would solve that issue, and not require evaluating for subquery or further complex on statement conditions.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Delete…  ·  Admin →

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Features  ·  Delete…  ·  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 Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Delete…  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    We would like to let you know that we have released dbForge SQL Complete, v5.6 where the issue you reported is fixed https://www.devart.com/dbforge/sql/sqlcomplete/download.html

    Thank you for your help in improving dbForge SQL Complete.

13. 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. If not intended, I'd absolutely love to see a fix. It's one of the very very few minor things I'd change about SQL Complete.

    THANK YOU for a great product!!!!!!!!!!

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

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

14. Double-clicking a snippet in the Snippet Manager Must Insert it into the SSMS editor

    It must be also possible to insert a snippet into the currently open editor window by just double-clicking it in the Snippet Editor (left pane)

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

15. Show list of procedures on typing procedure name even with no EXEC

    Show the list of available procedures when start typing a procedure name, for example:

    sp_proc1

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Delete…  ·  Admin →

16. Active Directory Integrated Authentication

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

    18 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

17. Put ON at top of suggestion list when using JOIN

    When typing inner join table1, make the ON keyword display at the top of the suggestion list

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Delete…  ·  Admin →

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Delete…  ·  Admin →

19. More estetics, more light

    A) connection identification
    a.1. paint background on crc24 of @@servername\db_name() with alfha at 15-20%
    a.2. allow a logo on right-bottom from local file or table.field of current connection

    B) if I have mySAP's 18.000 objects....
    b.1. allow completition ondemand on key (TAB) with rotation searching:
    objs: tblarc1, tblarc2, ...
    select * from arc{1°TAB} -> tblarc1 {2°TAB} -> tblarc2
    (can rotate or use SHIFT+TAB to go back)
    b.2 show tooltip with complete list of fields when mouseon obj/sp/fn/etc. identifier (of course the info gathering come from a separated thread or stop if mouse exit from tooltip area)

    C) editing
    c.1. auto case watching 1st two chars of line/text/prev word.
    c.2. special inline SP expantion ho metacommand as:
    proc#test! -> the ! activate
    call of "mySP" with param "proc#test"
    and the output replace proc#test!
    So I can integrate code develop with my meta-data
    c.3 config from a local.svr.db to allow developer's farm common style

    A) connection identification
    a.1. paint background on crc24 of @@servername\db_name() with alfha at 15-20%
    a.2. allow a logo on right-bottom from local file or table.field of current connection

    B) if I have mySAP's 18.000 objects....
    b.1. allow completition ondemand on key (TAB) with rotation searching:
    objs: tblarc1, tblarc2, ...
    select * from arc{1°TAB} -> tblarc1 {2°TAB} -> tblarc2
    (can rotate or use SHIFT+TAB to go back)
    b.2 show tooltip with complete list of fields when mouseon obj/sp/fn/etc. identifier (of course the info gathering come from a separated thread or stop if mouse exit from tooltip area)

    … more

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Delete…  ·  Admin →

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

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Delete…  ·  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.