277 results found
-
Support dynamic formatting using @SQLComplete tag to override a setting
There may be times when you would like to switch the formatting for a particular section of code because the global settings would not be most appropriate.
For example let's stay in SELECT statements you have "Stack Columns" checked with "Simple List" selected. This may be the desired format for 90% of the cases, however when there is a table with a large number of columns(50+), it could be more beneficial to view them on a single line so to see the query as a whole.
If you could add a comment before the query
--@Begin-SQLComplete Select-SelectList-StackColumns = True; Select-SelectList-StackColumns-Option=SingleLine…4 votes -
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 -
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 -
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
- Don't see your idea?