313 results found
-
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 -
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 -
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 -
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 -
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) respondedCould you please provide us the specific example of this?
-
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 -
Remove empty lines at the end of a batch
For example:
I have such code:
CREATE PROCEDURE dbo.Proc9999999
AS
BEGIN
SELECT 1
END
--many empty lines hereGO
Here what I will get after formatting:
CREATE PROCEDURE dbo.Proc9999999
AS
BEGIN
SELECT 1
END
GO3 votes -
auto alias with full table name or allow rename for non-aliased names
This will interface beautifully with the rename option that is included with SQL complete. Frequently i'll copy code sets that use two different objects or start as table reads and later become a read from a temp table. being table to change the "from" and easily being able to the rename the alias/table to the new source and have all other references to it be updated as well would be great
3 votesAdminDevart (_, Devart) respondedCould you please provide us an example of this?
You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
SQL file/tab comparison within SSMS
It would be great if you could do SQL file/tab comparison within SSMS.
1 vote -
1 vote
-
Add to formatter - Built-in Variable Case
In the formatting profiles, I would like built-in variables to be all-caps, while user variables left as declared
e.g. @MyVariable should stay as-is, but @@ROWCOUNT should be all-caps
1 vote -
Add formatting options for Window Functions
Add formatting options specific to Window Functions (e.g. ROW_NUMBER) for line breaks and spacing on the different arguments part of the function PARTITION BY, ROW, ORDER BY etc.
7 votes -
Collation names enclosed in square brackets is invalid
I have "Enclose identifiers within square bracket" set to "Always", which in most cases are great.
However, collation names are also being enclosed in square brackets, which seems to be invalid.
Please correct.1 voteAdminPMs (Admin, Devart) respondedCould you please specify what product version you are using?
A video or screenshots would be also of help.
-
Set different default schema in individual query panes
Add the ability to work in a different schema as default from the user's default schema. This will facilitate easier working with schema-less scripting, in a database with multiple schemas with similar/identical table/view setup.
1 vote -
Alphabetical listing when creating a SELECT list
Allow for an alphabetical listing when creating a SELECT list? It makes it difficult to quickly check the checkboxes when quickly adding columns.
7 votes -
Better intellisense for temp tables for DROP TABLE IF EXISTS
I frequently have code like this:
SELECT *
into #mytemptable
FROM mytable mand then I remember I need to drop the temp table if it exists.. so I start typing
DROP TABLE IF EXISTS # when I get to this point, I wish the intellisense would recommend #mytemptable but it only recommends previous #temp tables. I wish for this type of statement, it would prompt for all #temp tables in the query window.DROP TABLE IF EXISTS # <-- intellisense here is needed
SELECT *
into #mytemptable
FROM mytable msee image... there is no intellisense
https://imgur.com/a/8xGvfbX1 voteAdminDevart (_, Devart) respondeddbForge parses the object only after it’s declared. So, if the table is declared in the INTO clause, it will be offered only below the place it’s declared in the script and not above.
-
Full-Text Search Intellisense
Hi,
I found that full text search intellisense is not there in current version of sql complete, whenever i search for contain or other functions full text search related functions there are not coming in the list. It would be very help full if you can add this feature in next update of sql complete.
Rest if found anything new enhancements to be made will post.Thanks
Ravinder1 vote
- Don't see your idea?