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

266 results found

  1. Automatically propose join tables when JOIN instruction is typed.
    Proposal should not be baseed on existing tables relationships since most ERP out there do not have such relationships within the database.

    What I would like is that the user can configure all joins he knows for each tables and when the user types a SELECT instruction with JOIN that SQL Complete propose the list of all preconfigured joins for the tables already part of the SELECT.

    Ex:
    SELECT fields
    FROM Table1
    INNER JOIN Table2 ON Table1Key=Table2.Key
    INNER JOIN <here SQL Complete> would propose all preconfigured joins for Table1 AND Table2

    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  ·  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. Problem find storage procedure when select text proceure name do not contain exec.

    Example:
    exec ProcedureName -this ok
    ProcedureName - this error Connot navigate to definition. Connot find referenced object.

    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  ·  Bugs  ·  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…)
    2 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)
  4. It would be nice to be able to specify a separate format for simple case statements with only one 'when' and possibly an 'else' clause. These can typically easily fit in one line, while complicated case statements benefit from taking up the additional lines to improve readability.

    declare @profit float = 10

    /* Simple case statement can fit on one line */
    select case when @Profit > 0 then 'Great' else 'Not so great' end

    /* Complex case statement requires multiples lines */
    select case
    when @Profit > 10000 then 'Nice!'
    when @Profit > 0 then 'OK'
    else 'You''re fired!'…

    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  ·  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. Within SSMS, allow for the saving of filters.

    Justification:
    Particularly within large databases, often there is a reoccurring need to work with just a subset of tables. Sometimes, within different contexts, the particular subset changes. Being able to easily apply commonly used filters can allow increased productivity by eliminating frictional work (e.g. scrolling and hunting). Additionally, when filters across object types can be applied, there can be a lot of power. For example, being able to filter a particular set of SQL Agent Jobs, associated tables, and procedures related to those jobs, allows a troubleshooting developer to quickly set into…

    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)
  6. The tooltip font is just too small ...

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. it would be very helpful if you have an option that encloses object names in quotes. The option should allow you to specify the quote characters to use (brackets vs quotes).

    This would transform references like:

    dbo.myTable

    To
    [dbo].[myTable]

    It would also be nice if this option could be set to be applied during auto-complete.

    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)
  8. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. DECLARE @table varchar(100)
    SET @table = 'claims'

    DECLARE @noScale varchar(255)
    SET @noScale = 'INT,TINYINT,BIGINT,MONEY,SMALLMONEY'
    SET @noScale=@noScale+',BIT,SMALLDATETIME,DATETIME' --Need for SQL2000
    SELECT colName = ',' +
    CASE
    WHEN C.CHARACTERMAXIMUMLENGTH IS NOT NULL
    THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE) + '(' + CAST(C.CHARACTERMAXIMUMLENGTH AS varchar(10)) + ')'
    WHEN C.NUMERICSCALE IS NULL
    THEN C.COLUMN
    NAME + ' ' + UPPER(C.DATATYPE)
    WHEN C.CHARACTER
    MAXIMUMLENGTH IS NULL AND CHARINDEX(C.DATATYPE, @noScale) > 0
    THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
    WHEN C.NUMERICPRECISION > 0 AND CHARINDEX(C.DATATYPE, @noScale) = 0
    THEN C.COLUMNNAME

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Currently SQL Complete has an option to automatically qualify column names. Unfortunately, turning the option on means turning it on for everything.

    I love that SQL Complete qualifies the column name with the table name in regular SELECT statements such as:

    SELECT t1.Column1, t2.Column2 FROM dbo.Table1 t1 JOIN dbo.Table2 t2 ON t1.Column1 = t2.Column1

    However, I find it unnecessary when you are dealing with only one table in an UPDATE/INSERT/DELETE statement. For example qualification is unnecessary in the following statements:

    UPDATE dbo.Table1 SET Column2 = 123 WHERE Column1 = 10
    or
    INSERT INTO dbo.Table1 (Column1, Column2) ...
    or
    DELETE FROM…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. There is a choice on Options > General named Highlight Occurrences. I don't like the way this looks with my color scheme. Suggestion: allow me to change the default highlight color or document where that color comes from in SMMS's color settings.

    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. Show the list of available procedures when start typing a procedure name, for example:

    sp_proc1

    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  ·  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. the original sql statment:

    SELECT *
    FROM T1 RIGHT JOIN T2 ON T1.ID1=T2.ID1

    after reorganize

    SELECT *
    FROM T2 LEFT JOIN T1 ON T2.ID1=T1.ID1

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. I would be helpful to be able to hide ID or partitioning columns that may not ever be needed when selecting data. They just get in the way when expanding SELECT * but are still necessary to the table structure.

    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. Option to have a paragraph, not just a break, between elements of the statements:

    SELECT field1

    FROM table

    WHERE field1 IS NOT NULL;

    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  ·  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. In Visual Studio there is a plug that allows you to have the document tabs down the right hand side, which when you have loads of files open is very useful, especially now we have widescreen monitors. However SSMS is behind the times and the tabs along the top isn't enough. Can you please add a feature to display the sql tabs down the side rather than the top.

    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)
  17. Click in Document Outline window on some outline shows code line in sql file. But it would be nice to highlight encapsulated outline after clicking in sql code file on some code line. Therefore the position in navigation tree will be clear everytime.

    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  ·  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. To prevent a snippet from getting inserted when the alias is the same as a snippet. Many times I will start a query and an alias is the same as the snippet. When i hit tab or enter that snippet in inserted in place of the alias. This is especially true when you have SSMS Tools installed and many of the snippets from it are one letter (s for select, e for execute and so on)

    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  ·  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. Exclude columns [v].IDENTITYCOL, [v].$IDENTITY from select when checking the table checkbox on the suggestion popup window

    example:
    SELECT [v].id, [v].name, [v].IDENTITYCOL, [v].$IDENTITY FROM table [v]

    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. 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)
  • Don't see your idea?