309 results found
-
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 -
Add a flag to individual snippets to exclude from formatting
Sometimes we have pre-defined snippets that are already formatted in a specific way, e.g. on one line, and shouldn't get adjusted by formatting.
To support this, add a couple of checkboxes to snippets:
[x] Exclude from line-break formatting
[x] Exclude from in-line character formattingThe first would cause formatting to ignore the snippet with regards to rules that insert line breaks; the second would cause formatting to ignore the snippet wit regards to non-breaking formatting (case, spacing, etc).
Common use-case; we have a subquery that gets used a lot to find the max value in a field, and if expanded…
3 votes -
Format multiple documents
In the Object Explorer of SSMS I would like the ability to format multiple documents via the context menu.
The menu item should be available for Database, Views, Programmability, Programmability/Stored Procedures and Programmability/Functions, and should format all documents in the 'folder'.3 votes -
Add an option to show/hide or find columns in the Results pane
It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.
6 votes
- Don't see your idea?