272 results found
-
implement new code formatting options
SELECT
......p.PersonType,
......p.NameStyle,
......p.Title
FROM
......Person.BusinessEntity be
INNER JOIN
......Person.Person p
............ON
..................be.BusinessEntityID = p.BusinessEntityID
INNER JOIN
......Person.PersonPhone pp
............ON
..................p.BusinessEntityID = pp.BusinessEntityID
..................AND
..................be.ModifiedDate = pp.ModifiedDateWHERE
............1 = 1
......AND
............p.Suffix = 'N'
......AND
............p.Title NOT IN ('A1', 'B1','C1')
......AND
............(
..................p.FirstName LIKE '%abc%'
..................OR
..................p.LastName LIKE '%def%'
............)Add the following options to customize the code formatter regarding the example located above:
For JOIN's
one indent less than currentFor WHERE clause
stack conditions
Line break after opening brace of logical operand
Line break before closing brace of logical operand
Indent condition in list braces
Wrap condition…23 votes -
The name of tables should be shown in the document outline for the SELECT, INSERT, UPDATE statements
0 votes -
Control of arithmetic operators
Along the lines of keeping function parameters on a single line, SQL Complete also needs to have some control over the treatment of arithmetic operators. For example:
SELECT
c1 + c2
/ c3 as Calculation
FROM t;most formatting packages will format by default as:
SELECT
c1 + c2 / c3 as Calculation
FROM t;Some of the more advanced packages will be able to specify what to do before/after each operator (usually whether to add a newline) but at the very least SQL Complete needs to be able to "gather" a calculation onto a single line.
1 vote -
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 -
Move Forward/Backwards Through Tabs as Displayed
There are a couple ways of doing this now in Visual Studio (Microsoft's own Productivity Power Tools 2012 is one), but none that work in SMSS. I would dearly love the ability, after custom-sorting my tabs, to be able to move forward and backwards through them in the displayed order.
Currently you can only move through your tabs in the order you last clicked on them -- similar to Alt-Tab in Windows -- but not necessarily in the order they appear visually. I'm thinking Firefox/Chrome/Internet Explorer-type "sensible" tab movement.
devart will be my eternal hero if SQL Complete had the…
3 votes -
Have shared settings and snippets
We have a team of people and we'd like them to have one set of settings and snippets rather than having to keep multiple up to date.
8 votes -
Email Query (not results)
How about adding the ability to send the contents of the query window out in an email? It's a feature I've never seen in an add-in, but it's one that I'd use almost daily. Even better would be the ability to attach the query or just have the query as the email.
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 -
Ctrl+D - for Duplicate text
Ctrl+D - for Duplicate text
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 -
Support formatting for ALTER TABLE
Support formatting for ALTER TABLE ... ADD CONSTRAINT ... CHECK ... constructions
0 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 -
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 -
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 -
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 -
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!
5 votes -
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 -
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
- Don't see your idea?