309 results found

1. AS keyword

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Dark theme for SSMS

   Hi, all. I'm really enjoying using SQL Complete. One feature that's been missing from SSMS is a dark theme. There is a way to hack a "dark theme" -- by changing a setting in a configuration file, but it's incomplete; ‘Object Explorer’ and ‘Output Window’ keep their blindingly white backgrounds. Please consider adding this feature to SQL Complete. Thanks

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Bug in SQL Complete when using spatial functions

   I have a Problem with spatial functions when using SQL Complete.
   SSMS 18.12.1 always hangs when geompetry functions are used in query editor and SQL Code Completion is turned on.
   eg.: geometry::STPointFromText(( ...
   I have to kill ssms in Taskmanager to recover.

   Please fix this, otherwise SQL Complete is a great tool. SSMS feels broken without it.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Document sessions

   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 name or something to warn about opening a 2nd tab with one that is already open would make a huge difference for me. (Other suggestions?)

   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… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Color brackets.

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

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Refactoring suggestions

   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 the source table for the alias
      if the new table does not contain column names used throughout the procedure,
      inexistent column names get underlined as expected in most cases (selects, joins on...) but not for ROW_NUMBER() OVER (PARTITION BY /ORDER BY) inside OVER block, it seems like it's a valid column name
      if renaming the alias works inside this blocks, so should the intellisense when changing the source of an alias in all places the alias is used

   otherwise it's great feature and thank You for it, really helps ;)

   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… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Bugs  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. F12

   По F12 объект ищется в текущей базе. Но поиск не срабатывает и падает с ошибкой если:

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

   Более того, вцелом неудобно сначала по F12 делать поиск, а потом дополнительно на найденом объекте по выпадающему меню выбирать - "открыть скрипт в новом окне". В конкурирующих разработках, даже в самых дешевых - есть возможность сразу показать скрипт создания объекта. Было бы намного удобнее просто на любом объекте - иметь возможность сразу посмотреть скрипт создания. Жду эту дороботку уже который год...

   По F12 объект ищется в текущей базе. Но поиск не срабатывает и падает с ошибкой если:

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

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

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Keep it light and simple
   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   under review  ·  2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Support for ANSI-quoted identifiers

   For example
   SELECT * FROM "Person" WHERE "Person".

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Once ON is typed put the name of the current procedure at the top of the suggestion list

    When creating a procedure, often the next step is to execute a piece of permission code. ie:

    CREATE PROCEDURE db.uspdbForgeSQLComplete
    GO
    GRANT EXECUTE ON ..... TO .....
    GO

    Once ON is typed it would be great if the prompts list included the name of the current procedure at the top of the list even if it hasn't yet hit that cache or been created.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Ability to insert frequently used templates without need to modify them

    Let's assume, a user have about 10 most frequently used templates that do not need to be modified after they have been inserted unlike snippets.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Option for Line break between tables in join

    Multiple tables in the join statement are indented correctly, but no option to add a line break between the table joins. I find this line break to help legibility when dealing with many tables in a join.

    I think adding the option "break before JOIN keyword" would solve that issue, and not require evaluating for subquery or further complex on statement conditions.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. Wrap string concatenation

    Have the option to set max length for concatenation string. I've seen this implemented in SQL Beautifier and it helped legibility on long strings.

    User should be able to choose max length of characters before wrapping begins, then wrapping begins with + at beginning of line.

    It changes string from long string that user must scroll or have word wrap affect.

    BEFORE:
    ,comment_string = 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text'

    to:

    ,comment_string = 'Sample text' + 'Sample text'
    + 'Sample text' + 'Sample text'
    + 'Sample text'

    This would be great to have!

    Have the option to set max length for concatenation string. I've seen this implemented in SQL Beautifier and it helped legibility on long strings.

    User should be able to choose max length of characters before wrapping begins, then wrapping begins with + at beginning of line.

    It changes string from long string that user must scroll or have word wrap affect.

    BEFORE:
    ,comment_string = 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text'

    to:

    ,comment_string = 'Sample text' + 'Sample text'
    + 'Sample text' + 'Sample text'
    + 'Sample text'

    This would be great to… more

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. Enumerate available event package names and event names in CREATE EVENT SESSION ADD EVENT

    Intellisense doesn't enumerate available event package names and event names in CREATE EVENT SESSION ADD EVENT ... clause.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. indent logical operator

    In a WHERE clause, there is an option to wrap before a logical operator, but then the operator is aligned with the WHERE keyword. I'd like an option to indent logical operators in the WHERE clause, so it's clear that they are under it.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. Subquery indentation aligned with paranthesis

    Requesting a tweak to the indentation level settings for subqueries.

    If I have it set to have closing parenthesis on a new line, I'd like the option to align the whole thing with the starting parenthesis, and this to be the alignment point of the subquery. Increases legibility when lots of subqueries are involved.

    Targeted format:
    select
    1
    ,2
    ,3
    from
    table11 t

    inner join table2 t2
    on t.value = t2.value
    
    inner join ( -- starting parenthesis
    
                select
                    1
                    ,2
                    ,3
                from 
                    subquerytable3
                where
                    test = test
                ) f on t.value = v.value
                    and t.value2 = v.value2
    

    where
    test = test

    CURRENT FORMAT ALIGNS TO THE KEYWORD ONLY, not parenthesis.
    select
    1
    ,2
    ,3
    from
    table11 t

    inner join table2 t2
    on t.value = t2.value
    
    inner join ( -- starting parenthesis
    
    select
        1
        ,2
        ,3
    from 
        subquerytable3
    where
        test = test
    ) f on t.value = v.value
        and t.value2 = v.value2
    

    where
    test = test

    Requesting a tweak to the indentation level settings for subqueries.

    If I have it set to have closing parenthesis on a new line, I'd like the option to align the whole thing with the starting parenthesis, and this to be the alignment point of the subquery. Increases legibility when lots of subqueries are involved.

    Targeted format:
    select
    1
    ,2
    ,3
    from
    table11 t

    inner join table2 t2
    on t.value = t2.value
    
    inner join ( -- starting parenthesis
    
                select
                    1
                    ,2
                    ,3
                from 
                    subquerytable3
                where
                    test = test
                ) f on t.value = v.value
                    and t.value2 = v.value2
    

    where
    test =… more

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Preserver user's auto selected result preference

    Long standing issue with SSMS 2012 that has still not been addressed by SSMS Team.

    See:
    Shortcut:
    Text Editor::Ctrl+Alt+Space Edit.ToggleCompletionMode Edit.ToggleCompletionMode True

    Toggles completion mode, however doesn't preserve this change for any other session. Very annoying, requiring extra keystrokes each time using intellisense.

    Links:

    http://connect.microsoft.com/SQLServer/feedback/details/686087/intellisense-completion-mode-does-not-persist

    http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/0bd35217-03bc-462c-9491-0cb58aecd38e/

    http://beyondrelational.com/modules/2/blogs/77/Posts/18084/0213-sql-server-2012-ssms-intellisense-completion-mode-feature-a-matter-of-user-preference.aspx
    http://stackoverflow.com/questions/10555138/ssms-2012-intellisense-behavior?lq=1

    You'd be popular if you could keep this mode preference for the user as designated! I would like the first result to be auto selected so I I hit tab it completes. As it is, it requires extra key strokes. Thanks!

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. Support formatting for ALTER TABLE

    Support formatting for ALTER TABLE ... ADD CONSTRAINT ... CHECK ... constructions

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Initial caps each word option for aliases

    Add the 'Initial caps each word' option to the 'Text Case -> Identifier Case' branch in formatting profiles.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. The name of tables should be shown in the document outline for the SELECT, INSERT, UPDATE statements
    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close