272 results found
-
TEST MODE
There should be a toggle-button that flips between a TEST mode and a production mode for your "code/code window"... And when its in TEST mode, whatever code is there, BEFORE it is executed, is WRAPPED in a Transaction AND rolled-Back.
APEX SQL has this feature, trying to switch to Devart, and missing it.
1 vote -
Allow the 'on' clause to be aligned with the JOIN clause
"Support" was of no assistance, but I'd like to have my 'On' clause aligned with the join clause, but it's not possible:
from
[ExtendedEvents].[Events] ee -- on new line
join
OtherTable
on -- inline with JOIN
OtherTable.[ID] = ee.[ID]
where1 vote
AdminDevart
(_, Devart)
responded
This can be setup as follows:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile and click the ‘Open Selected…’ button.
4. Navigate to the ‘SELECT → FROM → JOIN’s’ section.
5. Unselect the ‘Indent ON keyword by 4 columns’ option. -
Problem find sorage procedure F12
Problem find storage procedure when select text proceure name do not contain exec.
Example:
exec ProcedureName -this ok
ProcedureName - this error Connot navigate to definition. Connot find referenced object.4 votes
AdminPMs
(Admin, Devart)
responded
The whole script should be valid. This is by design.
-
Can write a label to any tab
I click new New Query, then a new Tab open, I wrote my code, then I click again New Query and other Tab open, so I dont want to save to disk this tabs, but I would like to rename and put a label on each so if I have 10 Tabs opened, I can identify quickly for the tittle each one.
1 vote -
Sync user settings and snippets across machines
Sync settings and snippets across machines.
For example, if I create an custom snippet on my laptop, then shift to my desktop, the snippet would sync'd to my desktop automatically
1 vote -
In 'where' clause align the conditions to allow easier column selection
"Support" were or no assistance. I'd like to align the where clause so that I can column select the conditions, bu aligning the logical operators with the where clause:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignmentcurrently the code gets formatted as:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignment1 voteAdminPMs
(Admin, Devart)
responded
Could you please provide us screenshots of the actual and expected results along with the script?
-
Store the history in text files and not a binary 'database'.
It makes searching for queries MUST easier and is a significant reason I will keep using a competitors product (with the resulting conflict between the 2)
1 vote -
Snipets Manager
I am missing a search box in the list snipets
3 votes -
Remove debug stamp in Releases (keep it for your Debug versions only or verbose mode)
Steps to reproduce:
- run app DebugView
- work with SQL Complete for sometime in SSMS
- keep watching DebugView until you'll see lots of debug messages generated by SQLCompleteExpected: no debug messages in Release binaries
Actual: there are debug messagesPlease chekc all other products for this.
1 voteAdminDevart
(_, Devart)
responded
We will fix it in one of the next product builds.
-
1 vote
-
I need snippet created by highlight then right click
I need snippet created by highlight then right click, not open from menu, that is too complicated. If create more, that cost too much time. We need simple but powerful, currently this feature not.
1 vote -
Drop-down list of history searches
Now, each time I want to search in Execution History I need to type keyword I want to find. It would be nice that it would be store last X searched keywords and it would be possible to select from drop-down menu those items
3 votes -
Conditional Alias using the right letter case
In the Alias settings I can choose to use upper case, which is fine, but when I do, all my conditional aliases are also all upper case, I would prefer to keep the upper/lower casing that I specified in the condition/action cells
1 vote -
Create SQL Complete for Azure Data Studio
I would like to start using Azure Data Studio (ADS), as it has some features missing in SQL Server Management Studio. However, I am always using Format Document (^K,^D) and Format Selection (^K,^F). I would also miss SQL Complete's code snippets in ADS. I like and use SQL Complete so much that this is the main reason I won't yet use ADS. If you made a plugin for ADS I would buy it.
100 votes -
SQL Complete does not support parsing SQL with valid PATINDEX function
SQL Complete does not support parsing SQL with valid PATINDEX function
1 voteAdminDevart
(_, Devart)
responded
Could you please provide us the specific example of this?
-
Stacked list with commas before items: make commas align with indent
I have tab size and indent size both set to 4, so most indented items are indented by 1 tab. This is what I want.
However, with a stacked list, I want the leading comma to be indented by 1 tab (and the first item by 1 tab plus 1 space).
At the moment, the commas are indented by 3 spaces. The only way I have found to change this is to set indent size to 5, but that then causes other indents to be 1 tab + 1 space.
3 votes -
Comment out or remove extraneous commas to prevent a syntax error.
Comment out or remove extraneous commas to prevent a syntax error. Often when I remove several columns I forget to remove the comma on the preceding line.
Ex. A
SELECT a,
b,
FROM worktableEx. B
SELECT ,b
,c
FROM worktable1 vote -
intellisense for tablevalued CLR functions should behave similar to other tablevalued functions
with tablevalued CLR functions, SQLcomplete shows both output and input variables in the tip, making it hard to use the correct input variables.
instead the tip should only show input variables when you are typing input variables and output variables when you are in the select part, right now both input and output variables are suggested regardless of where you are typing, making it next to useless in aiding with the SQL typing.
I submitted this as a bug, but got the reply that this was by design, but with no explanation as to why they think this is a…1 vote -
Expand contect menu "Generate Script As" with an "As-Is" option.
This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.1 vote -
Add Export Query Result to Excel' option
It would be great if you could add a 'export query result to Excel' option in SQL Complete Thanks !
36 votes
- Don't see your idea?