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. When typing "JOIN [start of table name]" I would like the suggestions shown by SQL Complete to be based on the foreign keys and [start of table name] instead as now, when it highlights the first table based on [start of table name].

    Example:
    in my database I have a UserAccount and a UserSecurityRole table that are joined by a foreign key so when I start typing
    SELECT * FROM UserAccount ua
    JOIN User

    SQL Complete shows all tables starting with "User" but the one highlighted in the suggestions list i UserAccount instead of UserSecurityRole with a foreign key, so…

    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. Like Microsoft's IntellySense does, when you open or write a script, case errors in variable names, table names, and field names are underlined in red (higlight) as a warning and can be corrected if desired.
    This funcionality is like a spell checker.
    You currently open a script and SQLComplete is not able to tell you what case errors there are.
    This is quite important in environments where this requirement is required to be met.

    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. I often use SQL to generate SQL commands based on information from sys tables. This enables me to keep things in sync.
    Currently I need to Ctrl-C my selection, open a new tab, Ctrl-V in it, and then hit F5.
    A context menu item, that does all this (except F5) would be a nice addition.

    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. The execution history is a great feature. It can be made more using if SQL Complete was able to persist column changes (moves or exclusions). Currently, the end user is able to move the columns, for example, move the Server column to the left or right. The end user can also remove unwanted columns. However if you close SSMS and reopen, the columns are back to their original positions. This is not very user friendly as the purpose of a user changing the column layout is to have it displayed the way they want.

    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)
  5. When hovering over a table name in the editor, show the Est. row count at the "top" of the tooltip rather than at the bottom, currently the tip runs off screen on tables with many columns, causing it to be invisible

    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)
  6. I previously used SSMSBoost. There was a feature, Query Post-Execution Handlers, that included Results per Email as an option. This feature leveraged PowerShell as the engine, perhaps because it was a Windows installation, and a "script generator" dialog box that converted selected options and variables into a PowerShell script and email message. I would have added a screen capture of this interface, but this post won't accept attachments. The feature also accepted a threshold so it would only apply to queries that exceed a specified number of seconds. It was nice to be able to set this up for long…

    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)
  7. When auto-expanding an insert or update statement by pressing the tab key, the column list provides default values for the columns. With DateTime and DateTime2 in particular, it would be helpful to configure if you want to use the UTC datetime or the current timezone. Our company exclusively stores datetimes in UTC, so to have this default this way would be extremely helpful!

    CREATE TABLE #tmp (ID INT, CreatedDateUtc DATETIME2, Name NVARCHAR(50))

    INSERT INTO #tmp (ID, CreatedDateUtc, Name)
    VALUES (0, SYSDATETIME(), N''); -- allow this to populate as SYSUTCDATETIME() or GETUTCDATE(), depending on DATETIME2 vs DATETIME

    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 want to create a snippet that will generate a new guid value (the actual value generated from NewId()).

    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)
  9. Include a formatting option to "Always include AS keyword for aliases". The goal would be to change

    SELECT
    *
    FROM
    [dbo].[Table1] [T]

    into

    SELECT
    *
    FROM
    [dbo].[Table1] AS [T]

    Note the AS added to the FROM clause. This option could be global (Misc group?) or could be a separate option for each relevant clause (SELECT for field names, FROM and JOIN for table names, etc.).

    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. Enhanced Documents Sessions

    The main issue I have with SQL Management studio is managing all the tabs and code. One great feature would be the ability to automatically group all sessions by the active database. A modern approach would be to have "grouping" tabs, where you can place code, or a tree approach with subtrees.

    The single biggest issue I have is editing stored procedures/functions. If you multiple tabs with the same proc and edit one, then open the other tab and edit by mistake, it is a disaster. Being able to label a session with the actual stored proc…

    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. Please add the ability to color brackets. Just like it happens in Excel, for example, when you write a function. The opening and closing brackets are marked in one color.

    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)
  12. 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)
  13. 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)
  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. 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)
  16. With the tab coloring feature, it can be difficult to tell which tab is the currently active tab just by looking at them. Some of the colors of the disabled tabs come through as slightly different than when they are active, but look like they might be active because they are close to other colors.

    I would suggest either making all inactive tabs gray, or to introduce some other type of visual queue to help easily distinguish active from inactive tabs.

    I can't upload a screenshot here but I do have one as an example.

    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?