310 results found
-
Suggest WHERE conditions
Let's say, there are tables A and B linked with a foreign key.
Currently, dbForge SQL Complete suggests joining conditions:
SELECT *
FROM dbo.A a
JOIN dbo.B b ON ->> a.id = b.idAs part of this feature, dbForge SQL Complete could also suggest conditions in the following queries:
SELECT *
FROM dbo.A a
OUTER APPLY (
SELECT TOP 1 *
FROM dbo.B b
WHERE ->> a.id = b.id
) tSELECT
*
, (
SELECT TOP 1 ', '
FROM dbo.B b
WHERE ->> a.id = b.id
)
FROM dbo.A aSELECT *
FROM dbo.A a
WHERE NOT EXISTS(…57 votes -
4 votes
-
5 votes
-
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 -
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 -
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 -
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 -
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
- Don't see your idea?