Skip to content

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

156 results found

  1. As a developer, I would like options to format Block Comments.

    Each of these would be check boxes to enable/disable the feature. The last two options would have a text input box at the end to allow the user to enter the character(s)

    ☑Insert empty line before block comments
    ☑Insert empty line after block comments
    ☑Add border above block comments using: *
    ☑Add border below block comments using: *

    Before:

    USE AdventureWorks2012
    GO

    /* First line of a multiple-line comment.
    Second line of a multiple-line comment. */

    SELECT * FROM HumanResources.Employee
    SELECT * FROM Person.Address /*Single line comment*/
    GO

    After:

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Hello,
    I would like to get new options for alias generation that are not based on first letters of the object name but more on parts of the name itself.
    I work with a database that uses the following name standard: T{1}{222}tablename where {1} equals the type and {222} equals the unique trigram for the table (ie: TRCUScustomer for customers table, R being a reference type). I would like the alias to use the {222} part of the name (so "cus" in this case).
    So a new rule such as "T*
    {3}*" where the 3…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. It can possibly be done with the 'snippet', but when I hit Ctrl- N in SSMS, it would be great if 'my' standard template opened. This allows me have the necessary 'set' options pre configured etc

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. It is very common to make typos or spell words incorrectly as you code or write comments. It would be nice to introduce a spelling check of the comments and optionally in variables, column names, table names, procs, functions similarly how it is done in PyCharm.

    That is especially useful when you create new tables. If you misspell a column name it is such a pain to fix it later.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. It would be really useful if the option is added to see NULL & NOT NULL Count info on the Grid aggregates info-bar along with other aggregates. This will save a lot of time in finding any null value if presents in large data result set.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. There should be a toggle-button that flips between a TEST mode and a production mode for your "code/code window"... And when its in TEST mode, whatever code is there, BEFORE it is executed, is WRAPPED in a Transaction AND rolled-Back.

    APEX SQL has this feature, trying to switch to Devart, and missing it.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. When I type group by and press the space bar to display "all non-aggregated columns" in the context menu. When I select this option, all columns that are not aggregated are added to the group with all their functions

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. CREATE TYPE dbo.MyType AS TABLE
    (
    MyTypeId UNIQUEIDENTIFIER NOT NULL
    , MyTypeContent1 VARCHAR(20) NOT NULL
    );

    DECLARE @a AS dbo.MyType

    INSERT INTO @a --> Tab-Tab expands just like it does for other table types.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. I click new New Query, then a new Tab open, I wrote my code, then I click again New Query and other Tab open, so I dont want to save to disk this tabs, but I would like to rename and put a label on each so if I have 10 Tabs opened, I can identify quickly for the tittle each one.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Sync settings and snippets across machines.

    For example, if I create an custom snippet on my laptop, then shift to my desktop, the snippet would sync'd to my desktop automatically

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. I would like to be able to use a different format for the DATE predefined literals than YYYY-MM-DD. It would be helpful to include one for YYYYMMDD ... or have literals for YEAR, MONTH, and DAY so I could create my own combination from them.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. It makes searching for queries MUST easier and is a significant reason I will keep using a competitors product (with the resulting conflict between the 2)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. There is server coloring in the project. But there are only a few colors I can choose. If I can do it like in SSMS Tool Pack, I can choose any color for the server

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    You might be referring to the Tabs Color feature that can be setup in the ‘Tabs Color’ section of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).

  14. I am missing a search box in the list snipets

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Either display the hardware hash in the about box or show the computer name in the manage license web page

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. We use SQL Complete to format our SELECT statements. So the following
    SELECT [aField] FROM [dbo].[aTable]
    turns into
    SELECT
    [aField]
    FROM
    [dbo].[aTable]

    However, this stament is then also transferred from
    SELECT @intVariable = 1
    into
    SELECT
    @intVariable =1

    This is messy, so when we're not selecting from a table, we would like SQLComplete to format our that statement into
    SET @intVariable = 1
    In this case it all fits nicely on a single line again.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. I need snippet created by highlight then right click, not open from menu, that is too complicated. If create more, that cost too much time. We need simple but powerful, currently this feature not.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Now, each time I want to search in Execution History I need to type keyword I want to find. It would be nice that it would be store last X searched keywords and it would be possible to select from drop-down menu those items

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. I would like to start using Azure Data Studio (ADS), as it has some features missing in SQL Server Management Studio. However, I am always using Format Document (^K,^D) and Format Selection (^K,^F). I would also miss SQL Complete's code snippets in ADS. I like and use SQL Complete so much that this is the main reason I won't yet use ADS. If you made a plugin for ADS I would buy it.

    98 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?