306 results found
-
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 -
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 -
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…
1 vote -
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 -
1 vote
-
Support for ANSI-quoted identifiers
For example
SELECT * FROM "Person" WHERE "Person".0 votes -
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 .....
GOOnce 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 -
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 -
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 -
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…
0 votes -
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 -
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 -
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 tinner 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 =…0 votes -
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 TrueToggles completion mode, however doesn't preserve this change for any other session. Very annoying, requiring extra keystrokes each time using intellisense.
Links:
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=1You'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 -
Support formatting for ALTER TABLE
Support formatting for ALTER TABLE ... ADD CONSTRAINT ... CHECK ... constructions
0 votes -
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 -
The name of tables should be shown in the document outline for the SELECT, INSERT, UPDATE statements
0 votes -
Ability to wrap parameters
Most of the time I prefer parameters on a single line, but in case they are many I like to wrap.. perhaps two or three in each line.
0 votes -
Ability to align opening braces in INSERT
For insert I would like the starting brackets of fields and values to be aligned.
The formatter produces
insert into Table (Field1, Field2)
values (1, ‚text‘);when ideally I would like
insert into Table (Field1, Field2)
values (1, ‚text‘);0 votes -
Show intellisense for stored procs located in Master database
Currently, Sql Complete doesn't show intellisense for procs in Master DB when the active connection is in a different database. These procedures are still runnable from any database, so it should still show intellisense. This should be enabled by default or at least have an option in settings.
0 votes
- Don't see your idea?