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

267 results found

  1. SQL Complete seems not to be able to keep function parameters "together" on the same line. For example, if a function is broken across several lines like this:

    SELECT
    SUM (c1,
    c2)
    FROM t;

    SQL Complete will not reformat to something like:

    SELECT
    SUM (c1, c2)
    FROM t;

    In general, function parameters seem not to be understood by SQL Complete. For example, it always considers AS as its own independent entity, despite it sometimes being in a function call such as:

    SELECT
    CAST (c1
    AS INTEGER)
    FROM t;

    gets incorrectly formatted as:

    SELECT
    CAST (c1 AS
    INTEGER)
    FROM t;

    instead…

    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  ·  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. Along the lines of keeping function parameters on a single line, SQL Complete also needs to have some control over the treatment of arithmetic operators. For example:

    SELECT
    c1 + c2
    / c3 as Calculation
    FROM t;

    most formatting packages will format by default as:

    SELECT
    c1 + c2 / c3 as Calculation
    FROM t;

    Some of the more advanced packages will be able to specify what to do before/after each operator (usually whether to add a newline) but at the very least SQL Complete needs to be able to "gather" a calculation onto a single line.

    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  ·  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. For example if i wrote a query like this SQL Complete will generate alias "ch":
    select * from crm.contacts_h ch

    but when I change table to contacts_d then I get additional "cd" alias generated, like this:

    select * from crm.contacts_d cd ch

    --
    Regards

    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  ·  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. A column specification in a SELECT list can become very long, especially when a CASE statement is replaced by the new Iif function. The column specification will not wrap, even when its length is far beyond the right margin. E.g:

    SELECT
    Bom.BillOfMaterialsID,
    Bom.ProductAssemblyID,
    Bom.ComponentID,
    CONVERT(bit, IIF((Bom.BillOfMaterialsID = Bom.ProductAssemblyID OR Bom.BillOfMaterialsID IS NULL AND Bom.ProductAssemblyID IS NULL) AND (Bom.ComponentID = Bom.ProductAssemblyID OR Bom.ComponentID IS NULL), 1, 0)) AS [Check]
    FROM AdventureWorks2012.Production.BillOfMaterials AS Bom

    The last column specification will always end up on a single line.

    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  ·  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. When displaying Goto Definition of a table it would be nice to include the field comments.

    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  ·  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. I would like to be able to control what the Current Statement is by adding empty lines. In the example below, the inner query cannot be executed by itself.

    Select a from
    (

    select 1 as a <-- Cursor Here

    )

    ) b

    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  ·  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. On Toad, if a query has parameters and you run it, it prompts (dialog pops up) for values for the variables and remembers them for the next execution, so you will do the key combination for Execute Current Statement and the first time enter the values, the next time the prompt dilog comes up, just hit enter.

    Select a from tbl where a = @Value

    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  ·  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. I find myself typing the same text alot. it would be useful to be able to hit a keyboard shortcut and insert something like 'WITH(NOLOCK)'. The intellisense helps, but this could perhaps speed it up even more.

    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  ·  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. http://sqlblog.com/blogs/aaron_bertrand/archive/2012/01/23/bad-habits-to-kick-using-as-instead-of-for-column-aliases.aspx

    It would be amazing to have the option to choose preference to have any column alias using "AS" flipped to assignment operator format with formatting preferences set.

    This has greatly enhanced my readability of complex procs and subqueries, especially as it aligns all the select values. Please consider this as an option. Having the option to flip back to AS would be nice, but my personal request is just to be able to flip AS to = assignment operations.

    Thanks!

    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  ·  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. Most of the time, the schema does not change when I connect to the server via SSMS. It would be nice if the auto suggestion cache would maintain itself between executions of SSMS, and only update the parts which are different from the last time. This would make the startup experience faster over slower links (like VPN) to the server. It also would help with databases that have a large number of objects.

    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  ·  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. The feature to go to the definition of an object in the object explorer currently does not support filters. If that subsection is filtered where the object should be, it will give an error instead of removing/changing the filter and locating 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…)
    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)
  12. I see table description extended properties displaying, but no details on the column description. I'd like this to be an option, so if a business uses this for documentation, you could easily look at the column definitions while using the intellisense suggestion list.

    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  ·  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. Issue: Formatter, add the ability to configure segment FROM represented JOIN in tabular form.
    Example: http://www.sql.ru/forum/actualutils.aspx?action=gotomsg&tid=976629&msg=16224475

    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)
  14. When a SET statement is a series of concatenated strings and you wrap the elements, the formatter aligns the wrapped strings with the SET keyword. They should have an option to be indented. Note below that periods denote indentation.:

    SET @Foo = @Bar + " some text " + @Baz +
    ......." some more text";

    Is formatted as:

    SET @Foo = @Bar + " some text " + @Baz +
    " some more text";

    Note that the indentation on the wrapped line is removed. It would be nice to have an option that results in:

    SET @Foo = @Bar +…

    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)
  15. when type insert into table then type Tab can get result like bellow
    Declare @SerNo XXX(SerNo RealType)
    Declare @NameXXX(NameRealType)
    Declare @ValueXXX(ValueRealType)
    insert into TestTable (SerNo,Name,Value)values(@SerNo,@Name,Value)

    it's real help for me

    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)
  16. Shortcut (Shift+Alt+O) to open an window with the names of all database objects (stored procedures, tables) and a textbox to enter the name (partial, multipart) of the object to find. While typing remove non matched names from the list. When selecting an object open a menu with options like Script Object AS (CREATE, INSERT etc).
    Then open a new SQL Server Management Studio window with the selected SQL code.

    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. Filter on the toolbar for filtering on all objects. To work in real time as you type. Current filter process is painful.

    Imagine I want to filter SP's, tables, views based on the string 'pack', for stuff like 'vwpackingtray' and 'sppackStrut'. At the moment I have to go to each object type area individually, open a poorly designed dialog, select focus before typing (?), type in the search term and save.

    I want a filter textbox in the toolbar, and as I type in it, the objects across the whole database(s) start to filter down to…

    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. My company uses SQL code embedded into xml documents which is edited in visual studio, so to format the entire files would be bad. The sql formatter in SSMS is outstanding. It would be nice to be able to format just a selection of text inside visual studio with the sql formatter using my setup profile

    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)
  19. replace "indent GROUP BY Phrase" with 2 options:
    1) "Indent GROUP BY Keyword"
    2) "Indent GROUP BY columns"

    the current options will now allow for formatting flexibility as it does for the where keyword/condition

    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)
  20. Currently SQL Complete only provides IntelliSense for linked servers with the server type of SQL Server. Please add support for other linked server types, such as Oracle, generic OLE DB, etc.

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