310 results found
-
customisable shortcuts to insert autotext
I find myself typing the same text alot. it would be useful to be able to hit a keyboard shortcut and insert something like 'WITH(NOLOCK)'. The intellisense helps, but this could perhaps speed it up even more.
1 vote -
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 voteAdminDevart (_, Devart) respondedCould you please provide us a concrete example of when it’s needed?
-
Improvement to Execute Current Statement.
On Toad, if a query has parameters and you run it, it prompts (dialog pops up) for values for the variables and remembers them for the next execution, so you will do the key combination for Execute Current Statement and the first time enter the values, the next time the prompt dilog comes up, just hit enter.
Select a from tbl where a = @Value
1 vote -
Improvement to Execute Current Statement.
I would like to be able to control what the Current Statement is by adding empty lines. In the example below, the inner query cannot be executed by itself.
Select a from
(select 1 as a <-- Cursor Here
)
) b
1 vote -
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 -
Goto Definition (tabel) include field comments
When displaying Goto Definition of a table it would be nice to include the field comments.
1 vote -
Enhancing Execute-Current-Statement with Execute-Current-Selection
I love SQL Complete's execute-current-statement functionality. I think it would greatly enhanced if it would automatically execute highlighted code. This could be a simple check: normally just execute-current-statement if no code is highlighted, but do a default SSMS execute (normally F5) if code has been highlighted.
I know I could always hit F5 but I think having both under the same keyboard shortcut would be very helpful. I never realized how useful it was until I began switching back to SSMS from Toad.
4 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 -
Ability to align opening braces in INSERT
For insert I would like the starting brackets of fields and values to be aligned.
The formatter produces
insert into Table (Field1, Field2)
values (1, ‚text‘);when ideally I would like
insert into Table (Field1, Field2)
values (1, ‚text‘);0 votes -
Ability to wrap parameters
Most of the time I prefer parameters on a single line, but in case they are many I like to wrap.. perhaps two or three in each line.
0 votes -
Don't generate alias if an alias is already present.
For example if i wrote a query like this SQL Complete will generate alias "ch":
select * from crm.contacts_h chbut when I change table to contacts_d then I get additional "cd" alias generated, like this:
select * from crm.contacts_d cd ch
--
Regards1 vote -
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
- Don't see your idea?