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

  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.

    122 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  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    122 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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

    69 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  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

    69 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  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    59 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  ·  Flag idea as inappropriate…  ·  Admin →
  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(…

    52 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  ·  Flag idea as inappropriate…  ·  Admin →
  7. 48 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  ·  Flag idea as inappropriate…  ·  Admin →
  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

    42 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  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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  ·  Flag idea as inappropriate…  ·  Admin →
  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.

    25 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  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. It would be great if you could add a 'export query result to Excel' option in SQL Complete Thanks !

    25 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  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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).

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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…

    22 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  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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
    
    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  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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  ·  Flag idea as inappropriate…  ·  Admin →
  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  ·  Flag idea as inappropriate…  ·  Admin →
  18. In a SQL script, I create several schemas, tables, and procedures. I'd like to have the ability to right-click an object name (in the editor), and select something like "Generate DROP IF EXIST".

    The tool would understand the object type and automatically add the following to the top of the file:

    DROP PROCEDURE IF EXISTS <SchemaName1.ProcName1>
    DROP PROCEDURE IF EXISTS <SchemaName2.ProcName2>
    DROP TABLE IF EXISTS <SchemaName1.TableName1>
    DROP TABLE IF EXISTS <SchemaName2.TableName2>
    GO
    DROP SCHEMA IF EXISTS <SchemaName1>
    DROP SCHEMA IF EXISTS <SchemaName2>

    13 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  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. In our schema, we have the unfortunate convention (if you can call it that...) of including underscores in many table and sproc names. For instance, a report sproc might be named ReportSalesByChannel. It would be awesome if the CamelCase interpretation either completely ignored the underscores in the name while providing the suggestions (so typing rsbc would suggest the above named report), or make it so the _ is one of the interpreted characters, which would allow rsbc to again suggest the above sproc. Right now any stored procedure with an underscore cannot be quickly suggested by any abbreviation…

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 13 14
  • Don't see your idea?