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. 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)
  2. 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)
  3. While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or to browse to the 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  ·  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. I love the "format document" and "format selection" features and would be interested in a "unwrap document" and "unwrap selection" feature.

    I use Notepad++ to do it currently but it is required when trying to paste SQL Code in Visual Studio.

    All it does is turn the code into 1 line...

    Thanks
    Yann

    2 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)
  5. I would like to format the comments that appear at the end of a line as part of the "stack columns" and "Table View".

    The stacking and table view for comments should have similar behavior as the column and alias view. They appear column aligned.

    Example (because posting destroys the formatting of my post, I'll use "." for spacing):

    SELECT
    .....column1.....AS a.........-- CommentA
    .....col2............AS b........ -- CommentB
    .....col3........... AS abc.....-- CommentC

    Thank you. Jake.

    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. If would be great if the autocomplete pick list was resized sqlcomplete would remember this size change.

    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)
  7. 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)
  8. I like to capitalise 'begin' and 'end' in lower case so my code looks like this:

    IF @Return = 1
    begin
    SELECT Name FROM Table
    end
    ELSE
    begin
    SELECT 0
    end

    The begin and end words should not be as bold as the sql statements, a bit like curly brackets are.

    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. 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…)
    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. 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…)
    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. In our company we are working with SAP Business One (SBO). SBO has a fixed database stucture which may not be changed at all. Relations are not directly built into the database.

    A custom relation mapping feature would help us with correct suggestions for the databases while still maintaining the database structure as it is.

    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)
  12. 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)
  13. 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.

    0 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)
  14. AutoComplete suggestion: MS Visual Studio does this, you should too.

    • Type in a function name: SQLComplete adds a full set of parentheses: SET X=myFunction()
    • Type in function parameters: SET x = MyFunction(1,2)
    • If user types closing paren, we have two, which is wrong. Current alternative is to right arrow or something to get past it.
    • SUGGESTION: If user types a paren immediately before a paren, skip past the paren instead!

    MS Visual Studio does this and it works great.

    0 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. I like BACKUP/RESTORE commands formatted so that all the options (especially MOVE options) are on separate lines in order to enhance readability.

    0 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. 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

    0 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)
1 2 3 4 5 6 8 Next →
  • Don't see your idea?