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

268 results found

  1. when db is offline during ssms startup - it won't get code completion.
    you have to bring it online and restart ssms

    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 clarify if it does not work only for offline databases or for each database on the server?

    A video or screenshots would be also of help.

  2. Guys,

    The main idea is following:

    When people enumerate column names between SELECT...FROM most of them can be separated on two behavioral groups:

    1) People who enumerates columns on a single line

    2) People who enumerates columns on a new line each.

    Both of these goups after previous, already typed, column name and before typing next type "," (comma) first and then " " (space - first group of people) or ENTER (second group).

    No one type next column name immidiately after comma.

    So really intellisense popup needed after SPACE or ENTER but not after COMMA.

    Please. disable displaying of…

    1 vote
    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)
  3. For any new subquery nesting level I would also suggest increment the indent from the previous query or subquery level, not all at same level.

    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)
  4. When I click right mouse button over table or view identifier in some query, I'd like to see a command 'Execute a query for the table in new document'.

    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. Auto parsing and delimiting IN clause values. As an app developer, many a times I find myself dealing with lengthy IN statements and would have to first paste my IN values in excel, run a script to add single quotes when values are strings and delimit each with a comma, then paste the result back into Management Studio and Enterprise Manager....e.g select * from table where col IN ('A', 'B',...)...basically your add-in with format the data once I paste into the IN...if column before the IN is string value, then it add quotes to the values and delimit and add…

    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)
  6. When running format document and there are syntax errors, it would be great if you could double click the error in the output window and it would take you to the error.

    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. It would be nice to be able to clear the results of the output window

    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. If you have a field name "Value" then automatic formatting mis-interprets this if it has an alias.

    Formatting:
    SELECT TableName.Value AS Alias
    FROM TableName

    Becomes:
    SELECT TableName.Valueas Alias
    FROM TableName

    Instead of
    SELECT TableName.[Value] AS Alias
    FROM TableName

    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)
    1. Click the checkbox of multiple fields of table joins when the table field pop-up is visible. 2. Auto create the field listing (with alias) in order of clicked when the pop-up is closed/dismissed.
    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)
  9. Is it possible that when i hover over an SP, that i see if the parameters have default values or 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…)
    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)
  10. It would be nice to have an option to limit intellisense to either 1) the currently selected database or 2) a pre-defined set of databases. That way I don't have irrelevant database object names showing up in the intellisense pop-up.

    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. When creating/modifying a stored procedure, it would be nice for the autotext to include the current procedure at the top (dare I say, like SQLPrompt)

    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)
  12. Example:

    IF 1 = 1
    begin
    SELECT
    'it does'
    print('it does')
    end
    else
    begin
    SELECT
    'it does not'

    print('it does not')
    end

    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)
  13. For example:
    IF @ID > 1
    BEGIN
    SELECT '1'
    FROM ID
    END

    Instead of
    IF @ID > 1
    BEGIN
    SELECT '1'
    FROM ID
    END

    1 vote
    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)
  14. When I am in Visual Studio and I hold down Alt and select a range of text, I can start typing and it will type into all rows. I use this frequently to type something that needs to be typed across several lines. In SQL Server Management Studio, the highlight process works, but as soon as you start typing, it only types in the first row that is selected.

    I would really like to see the input behavior from Visual Studio mimicked in SSMS.

    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)
  15. I'd really like the ability to have a stack option for the wrap condition in the FROM > JOIN options. What I mean is, I want to align conditions by the column name like this:

    JOIN Person.Address AS a
    ON e.ModifiedDate = a.ModifiedDate
    AND e.rowguid = a.rowguid

    I'd like the two "e." to align. Simply inserting a tab after ON and after AND will achieve 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…)
    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)
  16. I'd like to align the columns in the where clause like this:

    WHERE
    ---------------a.AddressLine1 IS NOT NULL
    --------AND a.AddressLine2 IS NOT NULL

    I'd like the two "a." to align.

    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)
  17. create an alias with a fixed length this will make the cut and past of a block much easier

    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)
  18. I often wish to trigger the "select * from" snippit by doing the following:'

    1) Drag table from ObjectExplorer to a new line (or copy/paste to new line)
    2) Press "Home" to get to beginning of line
    3) Press "ssf" then "tab" to fire the trigger

    The problem is that because the tablename is connected to the snippit, the snippit doesn't fire, and i have to then add a space, go back one spot, then hit tab.

    The snippits also seem to require that all code on the rest of the page be correct. Often I have an open query…

    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)
  19. Ctrl+D - for Duplicate text

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