272 results found
-
Automatically replace AS alias with "=" assignment operator (or vice versa) based on formatting preference
It would be amazing to have the option to choose preference to have any column alias using "AS" flipped to assignment operator format with formatting preferences set.
This has greatly enhanced my readability of complex procs and subqueries, especially as it aligns all the select values. Please consider this as an option. Having the option to flip back to AS would be nice, but my personal request is just to be able to flip AS to = assignment operations.
Thanks!
1 vote -
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 -
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 vote
AdminDevart
(_, Devart)
responded
Could you please provide us a concrete example of when it’s needed?
-
Show intellisense for stored procs located in Master database
Currently, Sql Complete doesn't show intellisense for procs in Master DB when the active connection is in a different database. These procedures are still runnable from any database, so it should still show intellisense. This should be enabled by default or at least have an option in settings.
0 votes -
Add procedure name as comment when using "Convert Exec to Script"
When using the Convert Exec to Script feature, it would be helpful to also include the stored procedure name at the very top to provide context to show from where the script was generated. see below. the bottom is what would show after Conver Exec to Script is completed.
exec uspMyProc
/* exec uspMyProc */
select *
from myTable6 votes -
DB (Catalog) filter
Similar to DB Object filter would like Catalogue / DB filter.
We used shared infrastructure so there heaps of DB / Catalogs to scroll through when are only working on 1 or 2.
6 votes -
Execute Current Statement - Key binding
PLEASE, allow user to change the keybinding for 'Execute Current Statement' , this should not be that difficult. Believe it or not, I have to move my hands on the keyboard quite a bit to type 'Ctl-Shift-E' .
If you can't open it up for a custom key binding , then at least give some options , like ' Alt-E ' would be very nice.
Related to this feature:
http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1335977-add-a-feature-to-run-current-statement25 votes -
Missing formatting options
Already the best formating add-in, but please make it truly complete with these few additions (some are from ApexSQL Refactor) to make it really perfect, thanks.
Line break immediately after WHEN, WHILE, IF keywords (to be more consistent like WHERE, HAVING, ON), and then indent their conditions.
Do not use a line break before the first item (or remove the existing one) if there is only one item (like SELECT with only one column).
Always use BEGIN / END for IF / ELSE, WHILE (add if missing).
Always use INTO for INSERT (add if missing).
Always use AS for aliases…
3 votes -
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 -
Goto Definition (tabel) include field comments
When displaying Goto Definition of a table it would be nice to include the field comments.
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 -
3 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 -
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 -
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 -
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
- Don't see your idea?