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

10 results found

  1. I have started using Serverless SQL Pool within SSMS. I have seen and voted for a post for Intellisense, but it would be good to be able to format a query too. For example the below query:
    SELECT cast(r.filepath(1) as varchar(100)) as [$FileName], ISNULL(SysRowId,0) AS _SysRowId, ISNULL(LSN,'') AS LSN, ISNULL(LastProcessedChangeDateTime,'1900-01-01') AS LastProcessedChangeDateTime, ISNULL(DataLakeModifiedDateTime,'1900-01-01') AS DataLakeModifiedDateTime, ISNULL(RECID,0) AS RECID, Language, Status, Stage, ISNULL(DataAreaId,'') AS DataAreaId, ISNULL(PARTITION,0) AS PARTITION, ISNULL(RECVERSION,0) AS RECVERSION
    FROM OPENROWSET(BULK 'Tables/StgTable/*.csv'
    ,FORMAT = 'CSV', PARSER
    VERSION = '2.0', DATASOURCE ='wsds', ROWSETOPTIONS = '{"READOPTIONS":["ALLOWINCONSISTENTREADS"] }'
    )
    WITH (
    SysRowId…

    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  ·  Bugs  ·  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. I have "Enclose identifiers within square bracket" set to "Always", which in most cases are great.
    However, collation names are also being enclosed in square brackets, which seems to be invalid.
    Please correct.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please specify what product version you are using?

    A video or screenshots would be also of help.

  3. SQL Complete does not support parsing SQL with valid PATINDEX function

    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  ·  Bugs  ·  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. Steps to reproduce:
    - run app DebugView
    - work with SQL Complete for sometime in SSMS
    - keep watching DebugView until you'll see lots of debug messages generated by SQLComplete

    Expected: no debug messages in Release binaries
    Actual: there are debug messages

    Please chekc all other products for this.

    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  ·  Bugs  ·  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 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

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please describe it in more detail and provide us the scripts?

    Screenshots would be also of help.

  6. Problem find storage procedure when select text proceure name do not contain exec.

    Example:
    exec ProcedureName -this ok
    ProcedureName - this error Connot navigate to definition. Connot find referenced object.

    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  ·  Bugs  ·  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. "Support" was of no assistance, but I'd like to have my 'On' clause aligned with the join clause, but it's not possible:

    from
    [ExtendedEvents].[Events] ee -- on new line
    join
    OtherTable
    on -- inline with JOIN
    OtherTable.[ID] = ee.[ID]

    where

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    This can be setup as follows:
    1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Formatting → Profiles’ branch.
    3. Select the active profile and click the ‘Open Selected…’ button.
    4. Navigate to the ‘SELECTFROMJOIN’s’ section.
    5. Unselect the ‘Indent ON keyword by 4 columns’ option.

  8. "Support" were or no assistance. I'd like to align the where clause so that I can column select the conditions, bu aligning the logical operators with the where clause:

    where
    [collectionid] > 5396 -- alignment
    and [session
    id] = 114 -- alignment

    currently the code gets formatted as:
    where
    [collectionid] > 5396 -- alignment
    and [session
    id] = 114 -- alignment

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please provide us screenshots of the actual and expected results along with the script?

  9. when db is offline during ssms startup - it won't get code completion.
    you have to bring it online and restart ssms

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please clarify if it does not work only for offline databases or for each database on the server?

    A video or screenshots would be also of help.

  10. Keep the comments when formatting procedures! IT can't be that all comments are removed by the formatting process! That happens to my code when I execute ALTER PROCEDURE!
    OR: Give me the option to NOT format my code! I use the Express Version.

    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  ·  Bugs  ·  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?