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. По F12 объект ищется в текущей базе. Но поиск не срабатывает и падает с ошибкой если:

    1. В базе стоит фильтр, и обьект не может быть найден при текущем фильтре.
    2. Если в окне студии открыт например код процедуры - и он трактуется как некорректный, например из за того что процедура уже есть в базе, а открытый скрипт начинается с CREATE PROCEDURE... То по F12 также выпадет ошибка. Нужно вручную заменить CREATE например на ALTER, только в этом случае поиск по F12 опять сработает.

    Более того, вцелом неудобно сначала по F12 делать поиск, а потом дополнительно на найденом объекте по выпадающему меню…

    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)
  2. I really love the refactoring features, but came across 2 things that might be addressed.

    1. when renaming procedure variable and the same variable name is used in other SP that is called using explicit variable assignment, e.g.
      EXEC dbo.otherSp @variable = @variable,
      the other SP variable gets renamed as well
      (e.g. rename
      @variable to @newName creates
      EXEC dbo.otherSp @newName = @newName
      instead of
      EXEC dbo.otherSp @variable = @newName)
      when variable is part of an EXEC command and parameter contains assignment operator, only the variable following an assignment operator should be renamed

    2. when leaving table alias as it is and changing…

    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)
  3. 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…

    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  ·  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. 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…)
    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 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.

  5. "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?

  6. "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.

  7. 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.

    4 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)
  8. 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…)
    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)
  9. 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…)
    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)
  10. 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.

  • Don't see your idea?