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

306 results found

  1. 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)
  2. 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).

  3. 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)
  4. 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.

    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  ·  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)
  5. 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)
  6. When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue

    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  ·  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)

    Could you please describe it in more detail and provide us the scripts?

    Screenshots would be also of help.

  7. 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)
  8. 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)
  9. 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)
  10. 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)
  11. Steps to reproduce:
    - run app DebugView
    - work with SQL Complete for sometime in SSMS
    - keep watching DebugView until you'll see lots of debug messages generated by SQLComplete

    Expected: no debug messages in Release binaries
    Actual: there are debug messages

    Please chekc all other products for this.

    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  ·  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)
  12. 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. 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)
  14. 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)
  15. 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)
    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)

    Unfortunately, we cannot reproduce the problem. Please, provide us with the following information:
    - which version of dbForge product are you using;
    - the whole script that we need to format (not a part of the code, but the entire document).

    We also want you to check that you are editing the settings for the active formatting profile. Note: the active formatting profile is given in bold in the profiles grid on
    SQL Complete – Options – Formatting – Profiles

  16. I have tab size and indent size both set to 4, so most indented items are indented by 1 tab. This is what I want.

    However, with a stacked list, I want the leading comma to be indented by 1 tab (and the first item by 1 tab plus 1 space).

    At the moment, the commas are indented by 3 spaces. The only way I have found to change this is to set indent size to 5, but that then causes other indents to be 1 tab + 1 space.

    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. Comment out or remove extraneous commas to prevent a syntax error. Often when I remove several columns I forget to remove the comma on the preceding line.

    Ex. A
    SELECT a,
    b,
    FROM worktable

    Ex. B
    SELECT ,b
    ,c
    FROM worktable

    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. In the Alias settings I can choose to use upper case, which is fine, but when I do, all my conditional aliases are also all upper case, I would prefer to keep the upper/lower casing that I specified in the condition/action cells

    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. with tablevalued CLR functions, SQLcomplete shows both output and input variables in the tip, making it hard to use the correct input variables.

    instead the tip should only show input variables when you are typing input variables and output variables when you are in the select part, right now both input and output variables are suggested regardless of where you are typing, making it next to useless in aiding with the SQL typing.
    I submitted this as a bug, but got the reply that this was by design, but with no explanation as to why they think this is a…

    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)
  20. This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
    I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.

    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?