309 results found
-
SQL Code Completion for INSERT INTO for a declared variable AS a user defined type
CREATE TYPE dbo.MyType AS TABLE
(
MyTypeId UNIQUEIDENTIFIER NOT NULL
, MyTypeContent1 VARCHAR(20) NOT NULL
);DECLARE @a AS dbo.MyType
INSERT INTO @a --> Tab-Tab expands just like it does for other table types.
3 votes -
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 votesAdminPMs (Admin, Devart) respondedThe 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 -
Snippets - Add Predefined Literals for Date Parts
I would like to be able to use a different format for the DATE predefined literals than YYYY-MM-DD. It would be helpful to include one for YYYYMMDD ... or have literals for YEAR, MONTH, and DAY so I could create my own combination from them.
4 votes -
Alias CTE like tables
When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue
1 voteAdminDevart (_, Devart) respondedCould you please describe it in more detail and provide us the scripts?
Screenshots would be also of help.
-
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) respondedCould 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 -
Server Color
There is server coloring in the project. But there are only a few colors I can choose. If I can do it like in SSMS Tool Pack, I can choose any color for the server
1 voteAdminDevart (_, Devart) respondedYou might be referring to the Tabs Color feature that can be setup in the ‘Tabs Color’ section of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
Snipets Manager
I am missing a search box in the list snipets
3 votes -
mark statement to exclude in execution history
Possibility to exclude lines of code in execution history that include senitive date (username and/or password)
example:
-- run code in sqlcmd mode
:connect [servername] -U my_account -P T0pS3cretP@ssw0rd!3 votes -
Display what PC an activation is against
Either display the hardware hash in the about box or show the computer name in the manage license web page
1 vote -
SET instead of SELECT whenever possible
We use SQL Complete to format our SELECT statements. So the following
SELECT [aField] FROM [dbo].[aTable]
turns into
SELECT
[aField]
FROM
[dbo].[aTable]However, this stament is then also transferred from
SELECT @intVariable = 1
into
SELECT
@intVariable =1This is messy, so when we're not selecting from a table, we would like SQLComplete to format our that statement into
SET @intVariable = 1
In this case it all fits nicely on a single line again.1 vote -
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) respondedWe 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 -
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.
99 votes -
Alias casing variation between columns and table Alias
When creating a formatting profile there is only one selection for Alias casing, in my personal experience my column alias casing differs from my table alias.
EX:
Select
det.name AS UserName
, det.id AS UserId
, det.phone AS UserPhone
, det.description AS UserBio
FROM dbo.exampletable detwhen running through my formaterr with the setting Alias Case set to 'Lower' it changes my column alias's whether they are snake_Case PascalCase to lower
TLDR : have a setting to alter column alias case individually rather than a global alias case option
1 voteAdminDevart (_, Devart) respondedUnfortunately, we cannot reproduce the problem. Please, provide us with the following information:
- which version of dbForge product are you using;
- the whole script that we need to format (not a part of the code, but the entire document).We also want you to check that you are editing the settings for the active formatting profile. Note: the active formatting profile is given in bold in the profiles grid on
SQL Complete – Options – Formatting – Profiles -
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
- Don't see your idea?