309 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 -
Sync edit in Highlight Occurences feature
SQL Complete (or SSMS) does a nice job of highlighting like words. Put the cursor on a table alias, and all occurences are highlighted for example.
Is it possible to edit all of these like Delphi's Sync Edit feature? Sometimes I would like to edit all occurrences and other times, just those in the highlighted text.
3 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.value2where
test =…0 votes -
Row_number() formatting issue
Formatting for rownumber() seems to have issues with breaking up the line. I don't know if the parser is evaluating it as a possible subquery, but it would be great to have the option for a single line or wrapped line rownumber(). A row_number() statement on 4-5 lines seems to be a little confusing.
3 votes
AdminDevart
(_, Devart)
responded
Could you please provide us a concrete example demonstrating this and describe it in more detail?
-
Ability to define default values for stored procedure parameters expanded by pressing Tab
When you type out "execute SPROCname" and then press Tab, SQL Complete very nicely builds out the list of parameters with commented out datatypes. Really like that. The one thing that would take this from being good to great would be if it filled in any default values from the procedure. Now that would be fantastic!
4 votes -
Add option to make snippits keywords only look to the left of the cursor of the current word.
I often wish to trigger the "select * from" snippit by doing the following:'
1) Drag table from ObjectExplorer to a new line (or copy/paste to new line)
2) Press "Home" to get to beginning of line
3) Press "ssf" then "tab" to fire the triggerThe problem is that because the tablename is connected to the snippit, the snippit doesn't fire, and i have to then add a space, go back one spot, then hit tab.
The snippits also seem to require that all code on the rest of the page be correct. Often I have an open query…
1 vote -
Option to add parenthesis into ON clause
Current formatting:
ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid
Expected:
ON (e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid)
3 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 -
Add option to align columns in WHERE clause
I'd like to align the columns in the where clause like this:
WHERE
---------------a.AddressLine1 IS NOT NULL
--------AND a.AddressLine2 IS NOT NULLI'd like the two "a." to align.
1 vote -
fixed length table alias
create an alias with a fixed length this will make the cut and past of a block much easier
1 vote -
1 vote
-
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 -
Support formatting of ORDER BY clause within OVER clause
currently if I format the following code
select
row_number() over (order by cl.f1
-------, cl.f2
-------)
- 1 as f2
,cl.f3
,cl.f4
from #clients clI get this output
select row_number() over (order by cl.f1
-------, cl.f2
-------)
------ - 1 as f2
,cl.f3
,cl.f4
from #clients clbut the desired output is
select row_number() over (order by cl.f1
---------------------------------------------,cl.f2
---------------------------------)
------ - 1 as f2
-------,cl.f3
-------,cl.f4
from #clients cl5 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 -
Add stack option for wrap condition in FROM and JOIN clauses
I'd really like the ability to have a stack option for the wrap condition in the FROM > JOIN options. What I mean is, I want to align conditions by the column name like this:
JOIN Person.Address AS a
ON e.ModifiedDate = a.ModifiedDate
AND e.rowguid = a.rowguidI'd like the two "e." to align. Simply inserting a tab after ON and after AND will achieve this.
1 vote -
When pressing "Enter" at the end of a line, the indentation of the next line should be same as the previous line
For example:
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
ENDInstead of
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
END1 vote -
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 -
Text editor improvement: Text column select enhancements
When I am in Visual Studio and I hold down Alt and select a range of text, I can start typing and it will type into all rows. I use this frequently to type something that needs to be typed across several lines. In SQL Server Management Studio, the highlight process works, but as soon as you start typing, it only types in the first row that is selected.
I would really like to see the input behavior from Visual Studio mimicked in SSMS.
1 vote -
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
- Don't see your idea?