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

309 results found

  1. Resharper, a popular addon for visual studio has a nifty feature where you can hit ctrl+t to open a compact search window where you can type part of a type name, and a list of clickable suggestions is presented as you type.

    http://www.jetbrains.com/resharper/features/navigation_search.html#Go_to_Type

    It would be quite handy to have something similar for Management Studio.
    Clicking any of the matches could open a new query window with an ALTER statement prepared.

    131 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. Declare @var1 INT, @var2 INT
    SELECT @var1 = 1, @var2 = 2
    SELECT @var1 [@var1]
    -- @var2 should be highlighted in the declaration since its assigned value is never used.

    128 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)
  3. I would like to start using Azure Data Studio (ADS), as it has some features missing in SQL Server Management Studio. However, I am always using Format Document (^K,^D) and Format Selection (^K,^F). I would also miss SQL Complete's code snippets in ADS. I like and use SQL Complete so much that this is the main reason I won't yet use ADS. If you made a plugin for ADS I would buy it.

    98 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 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. Microsoft's SQL Server Management Studio puts square brackets [ and ] around everything scripted or dragged/dropped from the Object Explorer to the scripting window.

    I want a feature to remove all square brackets.

    I currently have to use SQL Management Studio search/replace to remove the brackets, and rather have the removal performed when I format the code.

    Jake

    73 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 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. Due to the nature of our data, we use NOLOCK on most of our queries. It would be useful for us to be able to automatically have (NOLOCK) included when part of a statement is auto-completed. It may be useful to have it so that this option can be turned on only in specific databases.

    63 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)
  6. Let's say, there are tables A and B linked with a foreign key.

    Currently, dbForge SQL Complete suggests joining conditions:

    SELECT *
    FROM dbo.A a
    JOIN dbo.B b ON ->> a.id = b.id

    As part of this feature, dbForge SQL Complete could also suggest conditions in the following queries:

    SELECT *
    FROM dbo.A a
    OUTER APPLY (
    SELECT TOP 1 *
    FROM dbo.B b
    WHERE ->> a.id = b.id
    ) t

    SELECT
    *
    , (
    SELECT TOP 1 ', '
    FROM dbo.B b
    WHERE ->> a.id = b.id
    )
    FROM dbo.A a

    SELECT *
    FROM dbo.A a
    WHERE NOT EXISTS(…

    57 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. 54 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)
  8. The ability to add folders in SSMS for database objects. I understand these folders would only be virtual.

    I know of one addin that has this feature. www.sqltreeo.com

    43 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)
  9. It would be great if you could add a 'export query result to Excel' option in SQL Complete Thanks !

    36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 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. It would be great if there was an option to import/export snippets in the "SQL Complete->Import and Export Settings".

    This way snippets could easily be shared between team members.

    29 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)
  11. It would be interesting to be able to "fold" and "unfold" a query from a single line state (still showing the full query) to a multiline, formatted state.

    The following query, for example,

    | |
    |+| SELECT * FROM SomeTable WHERE SomeField = 3.14;
    | |

    would unfold to

    | |
    |- | SELECT
    | | *
    | | FROM
    | | SomeTable
    | | WHERE
    | | SomeValue = 3.14;
    | |

    and back.

    28 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)
  12. PLEASE, allow user to change the keybinding for 'Execute Current Statement' , this should not be that difficult. Believe it or not, I have to move my hands on the keyboard quite a bit to type 'Ctl-Shift-E' .

    If you can't open it up for a custom key binding , then at least give some options , like ' Alt-E ' would be very nice.

    Related to this feature:
    http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1335977-add-a-feature-to-run-current-statement

    25 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)
  13. SELECT
    ......p.PersonType,
    ......p.NameStyle,
    ......p.Title
    FROM
    ......Person.BusinessEntity be
    INNER JOIN
    ......Person.Person p
    ............ON
    ..................be.BusinessEntityID = p.BusinessEntityID
    INNER JOIN
    ......Person.PersonPhone pp
    ............ON
    ..................p.BusinessEntityID = pp.BusinessEntityID
    ..................AND
    ..................be.ModifiedDate = pp.ModifiedDate

    WHERE
    ............1 = 1
    ......AND
    ............p.Suffix = 'N'
    ......AND
    ............p.Title NOT IN ('A1', 'B1','C1')
    ......AND
    ............(
    ..................p.FirstName LIKE '%abc%'
    ..................OR
    ..................p.LastName LIKE '%def%'
    ............)

    Add the following options to customize the code formatter regarding the example located above:

    For JOIN's
    one indent less than current

    For WHERE clause
    stack conditions
    Line break after opening brace of logical operand
    Line break before closing brace of logical operand
    Indent condition in list braces
    Wrap condition…

    23 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)
  14. Add vertical scroll bar to 'Quick object info' hint to make it possible to view the complete list of the table columns (table with more than 60 fields).

    23 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)
  15. A popup that list recently used/pinned servers-database
    allowing for 1-click switch to that database while writing your query.
    A shortcut key for this would be appreciated.

    The Current default SSMS behaviour > Select a server then select a database then continue working. sometimes ones default database is set to master/orsomedb which is inconveinient and always has to switch.

    19 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)
  16. There should be a global empty line management structure for formatting. It would be nice to see:

    - Add empty line before/after keyword
    - Remove empty lines
    - Add empty line between statements
    
    17 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)
  17. For example, let's assume this is the output from a query:

    id name role

    1 Torn ADMIN
    2 John CLERK
    3 Adam SUPER

    I would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.

    In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
    name = 'Adam' and role = 'SUPER'

    16 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)
  18. Offer refactor option that fully qualifies object names with schema. I know the option is there to do this when typing, ensuring aliased/qualified names. However, one feature in SQL Prompt from RG that is pretty amazing is the option to "refactor-qualify", and it will parse all the object schema names and ensure your proc/table/view/etc calls have the schema name in front of them. This is considered a good practice, but doing manually is very time intensive.

    16 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)
  19. After I create a query in Sql Management Studio, what I usually do is copy the sql to code. I'm programming in c# and when I copy the sql to code, I must add parentheses at the start and the end of each line with also a '+' character to tells compiler to combine line.

    A very beautiful feature would be to add a shortcut to copy the sql into the clipboard but with these parentheses and '+' character. After that, I just simply have to paste it without error directly into my code.

    Another very beautiful feature would be…

    14 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)
  20. User Defined Types seem to have no intellisense or completion. Hovering over them shows no information about them. SQL Complete does not offer to complete the field list when inserting into them.

    This is extremely annoying. Please add intellisense and completion for UDTs!

    13 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)
← Previous 1 3 4 5 15 16
  • Don't see your idea?