158 results found
-
Vertical Tabs for Files
In Visual Studio there is a plug that allows you to have the document tabs down the right hand side, which when you have loads of files open is very useful, especially now we have widescreen monitors. However SSMS is behind the times and the tabs along the top isn't enough. Can you please add a feature to display the sql tabs down the side rather than the top.
3 votes -
rename
It would be very helpful to be able to right click on a tab in SSMS and have the option to rename it.
I currently have "SSMS Tools" installed to be able to accomplish this. Would be great to have the option in SQL Complete and be able to uninstall "SSMS Tools"
3 votes -
Create SQL Complete Extension for Visual Studio Code
Create SQL Complete Extension for Visual Studio Code
More and more I find our developer teams using Visual Studio Code as single IDE for all development and scripting. While the SSMS and Visual Studio extensions are great, most of our developers are not using those tools as much and find it cumbersome to open up the supported IDE's to get SQL Complete's benefits.3 votes -
3 votes
-
Allow hiding of standard columns when expanding "SELECT *" with TAB
I would be helpful to be able to hide ID or partitioning columns that may not ever be needed when selecting data. They just get in the way when expanding SELECT * but are still necessary to the table structure.
3 votes -
More Intelligent Intellisense
While camel casing matching is extremely helpful, it breaks when adding middle characters to it, perhaps consider adding to it the same way Visual Studio does it, it’ll be much more helpful.
For example, consider I have a column "FinalSellingFee" and a column "FreeShippingFunction", when I enter "fsf", both appear, now I only want the second, in Visual Studio I'll simply enter "fsfu" (adding a "u" at the end), or "fshf" (adding an "h" after the "s"), and it'll automatically get that I want the second. It makes it so much easier and quicker.
3 votes -
Keep list members open
It would be awesome, if you easily could select more than one suggestion in the "List Members" dropdown.
I often need to choose more than one field from a table - and if the table needed isn't the first one, it takes some extra typing to find it.
One option could be to leave the dropdown open when choosing an item. Another option (Stolen from LinqPad), is to press a dedictated key (½ or ` in LinqPad) which chooses it, but leaves the suggestion list open.
3 votes -
Format Block Comments
As a developer, I would like options to format Block Comments.
Each of these would be check boxes to enable/disable the feature. The last two options would have a text input box at the end to allow the user to enter the character(s)
☑Insert empty line before block comments
☑Insert empty line after block comments
☑Add border above block comments using: *
☑Add border below block comments using: *Before:
USE AdventureWorks2012
GO/* First line of a multiple-line comment.
Second line of a multiple-line comment. */SELECT * FROM HumanResources.Employee
SELECT * FROM Person.Address /*Single line comment*/
GOAfter:
…
3 votes -
Option to Format Index Statements
As a user it would be helpful to be able to customize how INDEX statements are formatted.
For example, it would be nice to be able to configure the indent for the second line where the "INCLUDE" statement is as shown below:
CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GOCurrently, SQL Complete formats the above text pushing the second line all the way to the left as shown below:
CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GOI am unable to find a current setting to indent the second…
3 votes -
Format Comments
I would like to format the comments that appear at the end of a line as part of the "stack columns" and "Table View".
The stacking and table view for comments should have similar behavior as the column and alias view. They appear column aligned.
Example (because posting destroys the formatting of my post, I'll use "." for spacing):
SELECT
.....column1.....AS a.........-- CommentA
.....col2............AS b........ -- CommentB
.....col3........... AS abc.....-- CommentCThank you. Jake.
3 votes -
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 -
Add option to adjust font on intellisense
No option to enlarge font. font size on intellisense is too small.
3 votes -
Add "Copy Current Statement (Ctrl+Shift+C)" & "Cut Current Statement (Ctrl+Shift+X)"
Execute Current Statement is a great feature to test out a statement currently being worked. Sometimes I like to break a statement out to its own query window for further development.
Copy (or Cut) Current Statement would work just like Execute Current Statement except it would copy (or cut) the statement to clipboard instead of executing it.3 votes -
Filter autocomplete list by any substring, not just word initials
Today, SQL Complete supports filtering the AutoComplete list by typing the initials of CamelCase identifiers. In Resharper, you can type any sequence of characters from the member you are looking for, and the autocomplete list is filtered by any members which contain the character you typed, as long as they appear in the same order you typed. This makes it easier to find what you are looking for, because it's easier to type parts of words than to remember the exact words and their initials.
3 votes -
Apply Block Comment to Selection
Provide a keyboard shortcut that applies block comment characters at the beginning and end of a selected text. Allow customization so that you can specify how many space characters or newline characters you want applied after the beginning comment characters/before the end comment characters.
3 votes -
When Formatting, Place Short Queries on a Single Line
I would like the option to specify that queries under a certain number of characters be formatted to be on a single line. This would also apply to subqueries so that if they are over the specified limit it follows the formatting rules already in place for subqueries but places simple subqueries on a single line.
So
SELECT
*
FROM
TABLE
WHERE
COL1 = 5;would become
SELECT * FROM TABLE WHERE COL1 = 5;
and
SELECT
COL1,
COL2,
COL3,
COL4,
CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
FROM
TABLE
WHERE
COL1 IN (
SELECT
COLB
FROM…2 votes -
format json output
Add an option to format JSON output with proper indentation and line feeds
2 votes -
2 votes
-
Add "Search" button to execution history and disable auto-search option.
When searching in execution history, the search value is used pretty quickly after you stop typing. This means that you have to wait for the search to finish even if you weren't done typing the search string. It also means that if you have a typo, you have to wait for the search to finish before you can correct it. I keep a long history of executed SQL, so each search takes a while to run.
In my opinion, it would be better to have a dedicated "Search" button so that you could submit your search string when you're finished…
2 votes -
Snippet - Wrap selected text in snippet
SQL Prompt has a fantastic feature that allows selected text to be wrapped up by pressing control + selecting snippet that utilizes the SELECTEDTEXT value. This is great for wrapping up text in "Begin try", "comment blocks" and other selection oriented snippets.
2 votes
- Don't see your idea?