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

275 results found

  1. E.g. by implementing the command that opens object definition in the new document.

    124 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  10 comments  ·  Admin →
  2. Have the ability to right-click or hover over an alias and be able to choose "Rename". By renaming the alias in one place it would automatically rename all other references to the alias in the query.

    For example: I create a table and it get aliased as r1. I then rename it to rnk, which would change the loin reference to rnk right away.

    75 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  3. A really cool addition to Sql Complete would be the ability to re-open tabs after a reboot or even after just closing SSMS.

    If you look at good quality text editors such as UltraEdit or even browsers such as Chrome & Firefox, they have the ability to remember which tabs were open.

    64 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
  4. Save a history of your executed SQL statements and allow you to search that history.

    Also save the current session so when you open SSMS you can click a button to open all the queries you has open when you last closed SSMS.

    55 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →
    1. Let's assume we have a table:

    CREATE TABLE dbo.Employee
    (
    EmployeeID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    IsMainWorkPlace BIT NOT NULL,
    TabelNumber VARCHAR(6) NULL,
    PersonID INT NOT NULL,
    DepartmentUID UNIQUEIDENTIFIER NOT NULL,
    DateIn DATETIME NOT NULL,
    DateOut DATETIME NULL,
    IsLabourUnionMember BIT NOT NULL,
    FiringReasonID INT NULL
    )

    1. Let's type the following construction and click TAB at the end:

    UPDATE dbo.Employee

    1. Suggest to expand columns just like it's implemented for INSERT:

    UPDATE dbo.Employee

    SET

    IsMainWorkPlace = DEFAULT /* IsMainWorkPlace - BIT NOT NULL /

    , TabelNumber = '' /
    TabelNumber - VARCHAR(6) /

    , PersonID = 0 /
    PersonID - INT…

    46 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 →
  5. I have a table (ObjectReference) and Sql Complete maps it to or1. I understand why it adds the 1 to avoid using the "or" keyword, but it would be nice to set up Sql Complete to use a more friendly keyword.

    One solution for this would be to allow me to map table names to alliases. Then, any time ObjectRerence is used, it would get oRef (or whatever) from the map.

    44 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. Introduce Regions like #region in C# for collapsable sections. This regions should have a "name" or comment and should be displayed in document outline for navigation. This has lot of benefits in large sql code files for better orientation and navigation.

    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →
  7. In the case where you have a nested (parenthesized) condition, increase the indention after the new line.

    How it currently operates:

    SELECT *
    FROM MyTable
    WHERE
    (a=1
    OR b=2
    OR d=5)
    AND c=3

    This doesn't really convey the fact that this is a subexpression, and it requires tracing the parenthesis with more complex queries. Something like this would be better:

    SELECT *
    FROM MyTable
    WHERE
    (a=1
    OR d=5
    OR b=2)
    AND c=3

    So for each parenthesis level with a different logical operator than the previous level (to help prevent over-indenting when parenthesis are applied too liberally), increase the indention level…

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  8. Everytime I upgrade, the installer forces me to exit Visual Studio. However, I only install SQL Complete for Management Studio. Please give me an option to ignore that error message

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  9. When autocompleting a column or table name, if the name is a SQL keyword, automatically place the brackets around the name. For example, the query "SELECT Version FROM Table" is currently auto-corrected to "SELECT VERSION FROM TABLE", which causes an error.

    Instead, it would be nice if SQL Complete auto-corrected to "SELECT [Version] FROM [Table]".

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →
  10. Support SSMS 2016 CTP

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Features  ·  Admin →
  11. When there's a valid sql object under the cursor in the text editor, two nice features (via context menu):

    1. Go to definition (select in object explorer)
    2. Script object (clipboard, new window, etc...)

    Also object names should be shown as a link if the Ctrl key in pressed. All object names in script shows as hyperlink. Ctrl+click or Ctrl+Enter on it opens the object definition in new tab.

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  12. When formatting a statement:

    SELECT sometable.fieldname AS something FROM sometable

    SQL Complete KNOWS the proper case of the table and field names (as it allows you to autocomplete them as you're typing it in). So, why doesn't it alter the case of them once they're already in the statement?

    If the table was actually SomeTable in the database, and the field was called FieldName, the "format" function should fix the statement like so:

    SELECT SomeTable.Fieldname AS something FROM SomeTable

    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
  13. I tried changing the Identifier to Uppercase to try to get the Table aliases to be uppercase but that made the tablename uppercase as well.

    30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  14. Show the table columns in the Intellisense when you create temp tables or declare table variables.

    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 →
  15. It would be a nice feature if you can add to database, schema and table brackets []. If you use certain characters like $ you have to enclose it with [].

    28 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    It’s implemented in the latest build of SQL Complete. Have a look at the “Enclose identifiers within square brackets” option.

  16. 27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  9 comments  ·  Admin →
  17. the format selection does expand the actual selection. Sometimes this is nice as it expands to include other bits that should have been selected but haven't other times it selects more than I want formatted. I think it should really only format what I actually select. Perhaps another option for format selection and related could be added too?

    26 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. Right alignment of keywords is an important formatting option.

    25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  19. It would be very nice to have options for separate formatting for subquery, for example:

    SELECT
    OrderID,
    OrderName,
    OrderDate
    FROM Orders
    WHERE ClientID = (SELECT ClientID FROM Clients WHERE ClientCode = 'ABC')

    Here, I need the main SELECT to be stacked and formatted appropriately, and subquery SELECT - to be wrapped and in one line).

    In large and complex SQL script this feature is invaluable.

    Currently it is not possible - one format is applied for everything.

    Thanks.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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