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

271 results found

  1. You already provide an option to align column aliases in a select statement by a table view option in the stack list.

    how about alignment for tables aliases in a JOIN statement

    e.g.

    SELECT *
    FROM dbo.table1 t1
    JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
    JOIN dbo.table t ON (t.c1 = tx2.c2)

    /*****************************
    ** To This
    ** using _ to simulate spaces
    /*****************************/

    SELECT *
    FROM
    ____dbo.table1 _t1
    JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
    JOIN dbo.table _
    _t _ON (t.c1 = tx2.c2)

    7 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  ·  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. Add formatting options specific to Window Functions (e.g. ROW_NUMBER) for line breaks and spacing on the different arguments part of the function PARTITION BY, ROW, ORDER BY etc.

    7 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)
  3. I would like an option for column aliases. I would like to choose between = or AS for the "Alias sign".
    The formatting should be done based on this "alias sign" and also be aligned by the alias sign.

    I prefer the = sign , but formatting doesn't seem to accept that as an alias now.

    Example before formatting:

    SELECT colA as [Column A], columnB as [ColumnLonger B]
    FROM Table_1 t

    Formatting when "=" is used as "Alias sign";

    SELECT [Column A] = t.colA
    ,[ColumnLonger B] = t.columnB
    FROM Table_1 t

    Formatting when "AS" is used as "Alias sign":

    SELECT…

    6 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  ·  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. Similar to DB Object filter would like Catalogue / DB filter.

    We used shared infrastructure so there heaps of DB / Catalogs to scroll through when are only working on 1 or 2.

    6 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)
  5. SQL Complete has an option to do renames within the current script. It would be great to support refactoring (rename) tables/views/procs/functions in dependent views/procs/funtions.

    For instance:

    CREATE TABLE dbo.Test (a INT, b INT, CONSTRAINT [PKdboTest] PRIMARY KEY (a))
    GO

    CREATE VIEW dbo.vwTest
    AS
    SELECT * FROM dbo.Test
    GO

    CREATE PROC dbo.spUpdateTest
    (
    @a int,
    @b int
    )
    as
    UPDATE dbo.Test
    SET b = @b
    WHERE a = @a
    GO

    On a separate screen (or from SSMS object explorer) choose refactor and change table name from "dbo.Test" to "dbo.GoodTableName" and SQL Complete would identify all objects where dbo.Test is…

    6 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. To do Api command lines to execute the rules of the SQL Complete in a batch process. Also provide Api command lines give the possibility to create a javascript process to run a task each 2 hours (for example) in the repository of the sp's (for instance). If there is an error an e-mail will be sent to responsible of that sp

    6 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. There are some identifiers and variables we'd like to force with CAPTITALS regardless of the formatting rules.

    Similar to the "General > Available prefixes:", could we have a "Force word formatting" option where we can enter these special word types? ie. TranSid ==> TRANSID

    6 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)
  8. It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.

    6 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. Similar to power tools for visual studio 2010: Pressing Ctrl + Click to go to the definition of the element. Also implement the sidebar where you graphically visualize the position of the matching elements and code errors.

    6 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)
  10. You can opt to have SELECT, GROUP BY, UPDATE, and other clauses stack their parameters. I think the IN clause should also have this capability.

    6 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)
  11. When using the Convert Exec to Script feature, it would be helpful to also include the stored procedure name at the very top to provide context to show from where the script was generated. see below. the bottom is what would show after Conver Exec to Script is completed.

    exec uspMyProc

    /* exec uspMyProc */
    select *
    from myTable

    6 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)
  12. Sometimes you want to find all the places where you have used a certain view/sp/function because you like to change something in that part. Now its hard to find

    6 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. currently if I format the following code

    select
    row_number() over (order by cl.f1
    -------, cl.f2
    -------)
    - 1 as f2
    ,cl.f3
    ,cl.f4
    from #clients cl

    I get this output

    select row_number() over (order by cl.f1
    -------, cl.f2
    -------)
    ------ - 1 as f2
    ,cl.f3
    ,cl.f4
    from #clients cl

    but the desired output is

    select row_number() over (order by cl.f1
    ---------------------------------------------,cl.f2
    ---------------------------------)
    ------ - 1 as f2
    -------,cl.f3
    -------,cl.f4
    from #clients cl

    5 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)
  14. You type in an insert statement. " Insert into dbo.Party" and then press tab. The below code is generated

    INSERT INTO Party
    (
    PartyTypeId,
    TenantId
    )
    VALUES
    (
    0 /* PartyTypeId - INT NOT NULL /,
    0 /
    TenantId - BIGINT */
    )

    Because most of the inserts, updates etc are mostly used inside stored procedures, and the values come from variables, I would like it to show :

    INSERT INTO Party
    (
    PartyTypeId,
    TenantId
    )
    VALUES
    (
    @PartyId /* INT NOT NULL /,
    @TenantId /
    BIGINT */
    )

    An updated statement will do the following snippet :

    UPDATE Party…

    5 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. When you select something in the SQL code and it selects all the other instances of it - e.g. a variable name, can you place coloured markers in the scroll bar of all the selected items, also for when you do a find as well. This is really useful feature in visual studio.

    5 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 you type out "execute SPROCname" and then press Tab, SQL Complete very nicely builds out the list of parameters with commented out datatypes. Really like that. The one thing that would take this from being good to great would be if it filled in any default values from the procedure. Now that would be fantastic!

    5 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)
  17. 5 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)
  18. We have a policy of always putting square brackets around identifiers in SQL Scripts. When using SQL Complete we have the option turned on to always use square brackets and this works fine when scripting brackets are inserted for us just fine. However when we open a legacy script and format the document, missing square brackets are not inserted so we have to manually go through the script to add them.

    If Always On is selected for square brackets then I press Ctrl+K Ctrl+D to format the document I would like to have missing square brackets inserted, that is all…

    5 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. DECLARE @table varchar(100)
    SET @table = 'claims'

    DECLARE @noScale varchar(255)
    SET @noScale = 'INT,TINYINT,BIGINT,MONEY,SMALLMONEY'
    SET @noScale=@noScale+',BIT,SMALLDATETIME,DATETIME' --Need for SQL2000
    SELECT colName = ',' +
    CASE
    WHEN C.CHARACTERMAXIMUMLENGTH IS NOT NULL
    THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE) + '(' + CAST(C.CHARACTERMAXIMUMLENGTH AS varchar(10)) + ')'
    WHEN C.NUMERICSCALE IS NULL
    THEN C.COLUMN
    NAME + ' ' + UPPER(C.DATATYPE)
    WHEN C.CHARACTER
    MAXIMUMLENGTH IS NULL AND CHARINDEX(C.DATATYPE, @noScale) > 0
    THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
    WHEN C.NUMERICPRECISION > 0 AND CHARINDEX(C.DATATYPE, @noScale) = 0
    THEN C.COLUMNNAME

    4 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. It would be nice to be able to specify a separate format for simple case statements with only one 'when' and possibly an 'else' clause. These can typically easily fit in one line, while complicated case statements benefit from taking up the additional lines to improve readability.

    declare @profit float = 10

    /* Simple case statement can fit on one line */
    select case when @Profit > 0 then 'Great' else 'Not so great' end

    /* Complex case statement requires multiples lines */
    select case
    when @Profit > 10000 then 'Nice!'
    when @Profit > 0 then 'OK'
    else 'You''re fired!'…

    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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?