271 results found
-
Improve standard filtering in Object Explorer
The standard filtering in Management Studio Object Explorer is rudimentary at best. I lack the ability to select multiple values, and use drop downs to do so. Or even better, use complex queries (with and/or/not), and maybe even save and reuse these for daily administration (much like snippets).
4 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 -
New Query Template
It can possibly be done with the 'snippet', but when I hit Ctrl- N in SSMS, it would be great if 'my' standard template opened. This allows me have the necessary 'set' options pre configured etc
4 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 -
Create a variable table based on a available table in the schema
DECLARE @table varchar(100)
SET @table = 'claims'DECLARE @noScale varchar(255)
SET @noScale = 'INT,TINYINT,BIGINT,MONEY,SMALLMONEY'
SET @noScale=@noScale+',BIT,SMALLDATETIME,DATETIME' --Need for SQL2000
SELECT colName = ',' +
CASE
WHEN C.CHARACTERMAXIMUMLENGTH IS NOT NULL
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE) + '(' + CAST(C.CHARACTERMAXIMUMLENGTH AS varchar(10)) + ')'
WHEN C.NUMERICSCALE IS NULL
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
WHEN C.CHARACTERMAXIMUMLENGTH IS NULL AND CHARINDEX(C.DATATYPE, @noScale) > 0
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
WHEN C.NUMERICPRECISION > 0 AND CHARINDEX(C.DATATYPE, @noScale) = 0
THEN C.COLUMNNAME…4 votes -
Add setting for color of "highlight Occurrences" or document where this is control in SMMS.
There is a choice on Options > General named Highlight Occurrences. I don't like the way this looks with my color scheme. Suggestion: allow me to change the default highlight color or document where that color comes from in SMMS's color settings.
4 votes -
Add an option to group database entities by schema rather than flat alphabetical.
Add an option to group database entities (tables, views, stored procedures, etc.) by schema rather than flat alphabetical. Click +/- sign to expand or collapse schemas.
4 votes -
alias second table reference
Automatically alias a second reference to a table even if "generate alias on commit" is not enabled
4 votes -
Don't qualify column name in certain scenarios
Currently SQL Complete has an option to automatically qualify column names. Unfortunately, turning the option on means turning it on for everything.
I love that SQL Complete qualifies the column name with the table name in regular SELECT statements such as:
SELECT t1.Column1, t2.Column2 FROM dbo.Table1 t1 JOIN dbo.Table2 t2 ON t1.Column1 = t2.Column1
However, I find it unnecessary when you are dealing with only one table in an UPDATE/INSERT/DELETE statement. For example qualification is unnecessary in the following statements:
UPDATE dbo.Table1 SET Column2 = 123 WHERE Column1 = 10
or
INSERT INTO dbo.Table1 (Column1, Column2) ...
or
DELETE FROM…4 votes -
Option to Format Index Statements
As a user it would be helpful to be able to customize how INDEX statements are formatted.
For example, it would be nice to be able to configure the indent for the second line where the "INCLUDE" statement is as shown below:
CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GOCurrently, SQL Complete formats the above text pushing the second line all the way to the left as shown below:
CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GOI am unable to find a current setting to indent the second…
4 votes -
Add option to adjust function tooltip font size
The tooltip font is just too small ...
4 votes -
Allow hiding of standard columns when expanding "SELECT *" with TAB
I would be helpful to be able to hide ID or partitioning columns that may not ever be needed when selecting data. They just get in the way when expanding SELECT * but are still necessary to the table structure.
3 votes -
Vertical Tabs for Files
In Visual Studio there is a plug that allows you to have the document tabs down the right hand side, which when you have loads of files open is very useful, especially now we have widescreen monitors. However SSMS is behind the times and the tabs along the top isn't enough. Can you please add a feature to display the sql tabs down the side rather than the top.
3 votes -
3 votes
-
Add option to adjust font on intellisense
No option to enlarge font. font size on intellisense is too small.
3 votes -
Add "Copy Current Statement (Ctrl+Shift+C)" & "Cut Current Statement (Ctrl+Shift+X)"
Execute Current Statement is a great feature to test out a statement currently being worked. Sometimes I like to break a statement out to its own query window for further development.
Copy (or Cut) Current Statement would work just like Execute Current Statement except it would copy (or cut) the statement to clipboard instead of executing it.3 votes -
Option to add a space after table alias.
To prevent a snippet from getting inserted when the alias is the same as a snippet. Many times I will start a query and an alias is the same as the snippet. When i hit tab or enter that snippet in inserted in place of the alias. This is especially true when you have SSMS Tools installed and many of the snippets from it are one letter (s for select, e for execute and so on)
3 votes -
Performance when starting visual studio
When starting visual studio with SQL Complete, it takes 15 seconds more to open Visual studio.
Maybe you can change to load the data after visual studio is opened? That way the delay is not visible to the user.
3 votes -
Extended Outline - Highlight outline which is marked by cursor
Click in Document Outline window on some outline shows code line in sql file. But it would be nice to highlight encapsulated outline after clicking in sql code file on some code line. Therefore the position in navigation tree will be clear everytime.
3 votes -
Paragraph between SELECT FROM WHERE etc.
Option to have a paragraph, not just a break, between elements of the statements:
SELECT field1
FROM table
WHERE field1 IS NOT NULL;
3 votes
- Don't see your idea?