275 results found
-
Sub condition formatting
Example of what you can get currently:
AND
(
old.TestString1 != new.TestString1
----OR old.TestString2 != new.TestString2
----OR old.TestString3 != new.TestString3
);Example of what I'd like to do:
AND
(
----old.TestString1 != new.TestString1
----OR old.TestString2 != new.TestString2
----OR old.TestString3 != new.TestString3
);4 votesThis can be setup as follows https://s8.postimg.cc/cqteckgid/sub_condition_formatting.png
-
Grid Aggregates Enhancements
Grid Aggregates Enhancements is a great feature. Here are some additional enhancements you can make:
- Add support for the date/time data types to MIN/MAX. Currently, it is not supported giving a message that it is not a number.
- Add MIN/MAX String length
- Have an option to make Grid Aggregates row permanently visible. It looks a bit funky when it pops-up on selection.
4 votes -
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 -
Disable theme colours or change to default colours in suggestion whindow
Hi! I have this theme applied to SQL Management Studio https://gist.github.com/605296 (http://studiostyl.es/schemes/jon-erickson-s-ragnarok-grey) but when the suggestion window appear is impossible to read some colours in the white background
3 votesWill be included in the next build.
-
Option to not automatically format document when opening a stored procedure.
When opening a complex stored procedure script, Management Studio hangs, because SQL Complete(v1.0.57) is trying to format the script.When disabling SQL Complete, the stored procedure is opening in less than 5 seconds.
3 votesFix will be included in the next build.
-
Prevent SQL Complete Locking SSMS
When you paste a large query containing lots of UNION statements, SQLComplete consumes all available CPU (one logical cpu only) and RAM and SSMS has to be killed to recover. I can email a sample query if required.
3 votesWe have fixed this problem. The new build is on site.
-
sql complete hangs when there are many procedures
Two ideas here:
1. Limit the suggestion list (entry in options dialog - "Max count suggestions"
2. Loading details could be async3 votes -
Show descriptions of objects
Show descriptions of objects on mouse hover or after configurable waiting period.
You can allow setting property of description of a table (e.g. description).
For tables columns you can show Description filed that we have in table designer.3 votes -
Different alias generation
For table name, for example, 'tMoneyCashOrder', auto-alias should be like 'tMCO', not "mco" like now. The first letter is often used to determine the type of object (table, view)
3 votesThe feature is implemented in SQL Complete v5.0. If the table name is ‘tMoneyCashOrder’, auto-alias will be generated as ‘TMCO’ or ‘tmco’.
-
Add the ability to disable intellisense integration in Visual Studio
Please add the ability to disable the intellisense integration in Visual Studio - I like the formatting options, but prefer the intellisense in VS. Currently, it's an "all or nothing" approach where I have to use SQL Complete Intellisense if I want the formatting.
3 votes -
Add the options to format DDL statements
Currently, the formatting options for DDL are rather limited. I would like to be able to control indentation of columns and braces in table definitions (to align the type declarations of the columns), as well as control over the structure of create index/constraint statements
3 votes -
3 votes
-
Option to align "ON" clauses to "JOIN" statements
SQL Complete currently formats ON clauses as follows:
SELECT
--BarcodeId,
--LastName,
--FirstName
FROM
--pplpeople
--INNER JOIN pplclient
----ON pplClient.PeopleId = pplPeople.PeopleId
WHERE
--BarcodeId = '12345'Need to be able to format ON clauses as follows:
SELECT
--BarcodeId,
--LastName,
--FirstName
FROM
--pplpeople
--INNER JOIN pplclient
--ON pplClient.PeopleId = pplPeople.PeopleId
WHERE
--BarcodeId = '12345'3 votes -
More control over join indents
In 4.0.53 I can't work out how to configure the formatting for a query to be...
SELECT
--column1
--column2
FROM
--table1
JOIN
--table2
----ON 1=1
----AND 2=2
JOIN
--table3etc
So basically only indenting the predicates not the keywords
3 votessee comments
-
Double-clicking a snippet in the Snippet Manager Must Insert it into the SSMS editor
It must be also possible to insert a snippet into the currently open editor window by just double-clicking it in the Snippet Editor (left pane)
3 votes -
Preserve the users cursor location when formatting is complete
When using the format selection command (or the entire document) the cursor position is reset to bottom of the document, instead of preserving the users cursor location. This is confusing as an end user. I'd like to recommend preservation of cursor location in the document.
3 votesThis issue is fixed in the latest build 4.0.72 of dbForge SQL Complete: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Support adding a numeric value next to new line or indent setting
Support adding a numeric value next to new line or indent setting so users could add 1-9 new lines or indents.
3 votes -
UPDATE and DELETE statement understanding table alias
When creating an UPDATE or DELETE statement and referencing a table alias. It cannot understand these. For example:
UPDATE A
SET ID = 5
FROM Table1 A
INNER JOIN Table2 B ON A.ID = B.IDSQLComplete does not understand the alias 'A' when writing the UPDATE or the SET statement.
3 votes -
3 votes
-
Oracle style formatting for SQL statements
It would be great if we could have the Oracle style SQL formatting option, where keywords are right justified and the arguments are left justified. Like below:
select col1, col2, col3
from dbo.tableName
where col2 = 1233 votes
- Don't see your idea?