230 results found
-
4 votes
-
4 votes
-
INSERT statement formatting
We need extra control of the formatting of various statements, e.g INSERTs. We like to have our INSERT statements formatted like:
INSERT INTO dbo.Test
(
UserID
, Name
, IsDeleted
)
VALUES
(
0 -- UserID - INT NOT NULL
, '' -- Name - VARCHAR(32) NOT NULL
, DEFAULT -- IsDeleted - BIT NOT NULL
)but we can't even get it close
4 votes -
Intellisense casing
I've entered this once before and was told that the latest version had fixed it. Finally got to downloading the current standard version (4.0.61) and it had not.
The issue is that there used to be an option in prior versions (3.x) that let you select the case of inserted key words and functions. This option was removed and now everything is inserted in all capitol letters. Either bring back the option or use SQL Management Studio's "Casing for built-in function names" IntelliSense setting.
4 votesPlease perform the following actions:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select a profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Expand the ‘Text Case → Identifier Case’ node.
6. Select the ‘Do not change’ option.You can also change the other settings under the ‘Text Case’ node.
NOTE: The latest build of dbForge SQL Complete is 4.0.69: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Add SQL type at end of tooltip
The tooltip on local declarations now includes the type (INT, BIGINT, etc.), but the column tooltips do not. Those are the ones I'm usually more interested in, and save me from having to look them up.
4 votes -
INSERT: Stack values on a row basis
It would be nice if INSERTs could have the VALUES stacked on a row basis. E.g.:
INSERT table (col1, col2)
VALUES (''val1", 2)
, (''val3", 4)
, (''val5", 6)4 votes -
CrLf after last GO
I'm always adding to batches and no blank line at EOF frustrates the heck out of me.
4 votes -
Add type into into Tooltip for table column
It would be very usefull if tooltip (OnMauseOver) for column name in select would also provide info about column type, for example
[table].[column](column) => [table].[column](column, int)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 -
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
- Don't see your idea?