272 results found
-
INSERT INTO expansion
When you type "insert into table(" popup with check-boxes shows up. After you select desired columns you have to add 'values' part manually.
It would be nice if after selection of desired columns and typing ")" 'values' part shows up with preset only for selected columns.
2 votes -
Separate (one-line) format for simple "when then else end" statement
It would be nice to be able to specify a separate format for simple case statements with only one 'when' and possibly an 'else' clause. These can typically easily fit in one line, while complicated case statements benefit from taking up the additional lines to improve readability.
declare @profit float = 10
/* Simple case statement can fit on one line */
select case when @Profit > 0 then 'Great' else 'Not so great' end/* Complex case statement requires multiples lines */
select case
when @Profit > 10000 then 'Nice!'
when @Profit > 0 then 'OK'
else 'You''re fired!'…4 votes -
Display column level extended properties if available in another column on intellisense popup
I see table description extended properties displaying, but no details on the column description. I'd like this to be an option, so if a business uses this for documentation, you could easily look at the column definitions while using the intellisense suggestion list.
1 vote -
Missing formatting options
Already the best formating add-in, but please make it truly complete with these few additions (some are from ApexSQL Refactor) to make it really perfect, thanks.
Line break immediately after WHEN, WHILE, IF keywords (to be more consistent like WHERE, HAVING, ON), and then indent their conditions.
Do not use a line break before the first item (or remove the existing one) if there is only one item (like SELECT with only one column).
Always use BEGIN / END for IF / ELSE, WHILE (add if missing).
Always use INTO for INSERT (add if missing).
Always use AS for aliases…
3 votes -
Automatically replace AS alias with "=" assignment operator (or vice versa) based on formatting preference
It would be amazing to have the option to choose preference to have any column alias using "AS" flipped to assignment operator format with formatting preferences set.
This has greatly enhanced my readability of complex procs and subqueries, especially as it aligns all the select values. Please consider this as an option. Having the option to flip back to AS would be nice, but my personal request is just to be able to flip AS to = assignment operations.
Thanks!
1 vote -
Add procedure name as comment when using "Convert Exec to Script"
When using the Convert Exec to Script feature, it would be helpful to also include the stored procedure name at the very top to provide context to show from where the script was generated. see below. the bottom is what would show after Conver Exec to Script is completed.
exec uspMyProc
/* exec uspMyProc */
select *
from myTable6 votes -
DB (Catalog) filter
Similar to DB Object filter would like Catalogue / DB filter.
We used shared infrastructure so there heaps of DB / Catalogs to scroll through when are only working on 1 or 2.
6 votes -
Customizable dictionary for auto complete
It would be great to have the ability to add some keywords didn't popup for auto-complete, like TRANSACTION, CURSOR,...so users have the control of what they need to be popup automatically.
1 vote
AdminDevart
(_, Devart)
responded
Could you please provide us a concrete example of when it’s needed?
-
Dynamic Grouping of Objects In Object Explorer
SQL Treeo offers some great functionality that really should be integrated with a tool like this, ie dynamic grouping of objects. When dealing with lots of objects in object explorer, it would be amazing to have functionality to group node objects by schema or by custom designation. I have a free open source version I'm using called SSMS Extender 2012, but again, implementation by SQL Complete would be a great feature and I guarantee would make more folks consider your product!
3 votes -
3 votes
-
Refactoring feature: Add Quotes to names
it would be very helpful if you have an option that encloses object names in quotes. The option should allow you to specify the quote characters to use (brackets vs quotes).
This would transform references like:
dbo.myTable
To
[dbo].[myTable]It would also be nice if this option could be set to be applied during auto-complete.
4 votes -
5 votes
-
4 votes
-
Word wrap column specification when longer than right margin, or when logical operators (NOT, AND, OR) are encountered
A column specification in a SELECT list can become very long, especially when a CASE statement is replaced by the new Iif function. The column specification will not wrap, even when its length is far beyond the right margin. E.g:
SELECT
Bom.BillOfMaterialsID,
Bom.ProductAssemblyID,
Bom.ComponentID,
CONVERT(bit, IIF((Bom.BillOfMaterialsID = Bom.ProductAssemblyID OR Bom.BillOfMaterialsID IS NULL AND Bom.ProductAssemblyID IS NULL) AND (Bom.ComponentID = Bom.ProductAssemblyID OR Bom.ComponentID IS NULL), 1, 0)) AS [Check]
FROM AdventureWorks2012.Production.BillOfMaterials AS BomThe last column specification will always end up on a single line.
1 vote -
The name of tables should be shown in the document outline for the SELECT, INSERT, UPDATE statements
0 votes -
Reconstituting function parameters on the same line
SQL Complete seems not to be able to keep function parameters "together" on the same line. For example, if a function is broken across several lines like this:
SELECT
SUM (c1,
c2)
FROM t;SQL Complete will not reformat to something like:
SELECT
SUM (c1, c2)
FROM t;In general, function parameters seem not to be understood by SQL Complete. For example, it always considers AS as its own independent entity, despite it sometimes being in a function call such as:
SELECT
CAST (c1
AS INTEGER)
FROM t;gets incorrectly formatted as:
SELECT
CAST (c1 AS
INTEGER)
FROM t;instead…
1 vote -
Order by in over clause (ranking functions) should have own settings
For ranking functions, the order by clause should not be formatted the same are the order by in a select.
sample:
Select
[RowNumber] = RowNumber() Over (Order By o.[Order ID]
, o.[Sort Order]
, o.[Entry No])8 votes -
Ctrl+D - for Duplicate text
Ctrl+D - for Duplicate text
1 vote -
auto select first selection on JOIN
so when typing a query that has a JOIN, SQL Complete does a great job guessing what to join ON. However, after typing the ON keyword in the join statement, SQL Complete pops up with list of candidates, and the first one in the list is usually what I want, but it is NOT SELECTED. so I have to take my hand off the keyboard, and select it (or hit the down arrow key), then hit TAB.
Why interrupt the devs flow? Just auto select the first one in the list!
3 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
- Don't see your idea?