292 results found
-
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 -
Alias CTE like tables
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
0 votes -
Formatting option for BACKUP/RESTORE commands
I like BACKUP/RESTORE commands formatted so that all the options (especially MOVE options) are on separate lines in order to enhance readability.
0 votes -
If user types a paren *immediately before* a paren, skip *past* the paren instead
AutoComplete suggestion: MS Visual Studio does this, you should too.
- Type in a function name: SQLComplete adds a full set of parentheses: SET X=myFunction()
- Type in function parameters: SET x = MyFunction(1,2)
- If user types closing paren, we have two, which is wrong. Current alternative is to right arrow or something to get past it.
- SUGGESTION: If user types a paren immediately before a paren, skip past the paren instead!
MS Visual Studio does this and it works great.
0 votes -
I often find when writing queries that I want to see a sample of data from the table I'm working with. It would by good if I could right cli
I often find when writing queries in the SQL edior that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu
0 votes -
Expand contect menu "Generate Script As" with an "As-Is" option.
This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.0 votes
- Don't see your idea?