142 results found
-
align equals
I like the option to align assignments in SELECT, UPDATE, etc, but I don't like that the alignment happens after the equals sign. It's much neater and easier to read when each column is aligned with an equals sign for the assignment.
(It's for this reason we use equals for column aliases rather than AS)
6 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 -
where used: From a view or sp or function get a list where you have used this
Sometimes you want to find all the places where you have used a certain view/sp/function because you like to change something in that part. Now its hard to find
6 votes -
Scrollbar highlighting
When you select something in the SQL code and it selects all the other instances of it - e.g. a variable name, can you place coloured markers in the scroll bar of all the selected items, also for when you do a find as well. This is really useful feature in visual studio.
5 votes -
Saved Filters in SSMS
Within SSMS, allow for the saving of filters.
Justification:
Particularly within large databases, often there is a reoccurring need to work with just a subset of tables. Sometimes, within different contexts, the particular subset changes. Being able to easily apply commonly used filters can allow increased productivity by eliminating frictional work (e.g. scrolling and hunting). Additionally, when filters across object types can be applied, there can be a lot of power. For example, being able to filter a particular set of SQL Agent Jobs, associated tables, and procedures related to those jobs, allows a troubleshooting developer to quickly set into…5 votes -
Insert missing square brackets when formatting selection or whole script.
We have a policy of always putting square brackets around identifiers in SQL Scripts. When using SQL Complete we have the option turned on to always use square brackets and this works fine when scripting brackets are inserted for us just fine. However when we open a legacy script and format the document, missing square brackets are not inserted so we have to manually go through the script to add them.
If Always On is selected for square brackets then I press Ctrl+K Ctrl+D to format the document I would like to have missing square brackets inserted, that is all…
5 votes -
Refactoring feature: Add Quotes to names
it would be very helpful if you have an option that encloses object names in quotes. The option should allow you to specify the quote characters to use (brackets vs quotes).
This would transform references like:
dbo.myTable
To
[dbo].[myTable]It would also be nice if this option could be set to be applied during auto-complete.
4 votes -
multiple row tab
Provide for MULTIPLE TAB ROWS like TabsStudio has. This way there's no need for the file menu drop-down list, no need to manually pin tabs, the tabs keep stable order.
Thanks
4 votes -
Add setting for color of "highlight Occurrences" or document where this is control in SMMS.
There is a choice on Options > General named Highlight Occurrences. I don't like the way this looks with my color scheme. Suggestion: allow me to change the default highlight color or document where that color comes from in SMMS's color settings.
4 votes -
Add an option to group database entities by schema rather than flat alphabetical.
Add an option to group database entities (tables, views, stored procedures, etc.) by schema rather than flat alphabetical. Click +/- sign to expand or collapse schemas.
4 votes -
New Query Template
It can possibly be done with the 'snippet', but when I hit Ctrl- N in SSMS, it would be great if 'my' standard template opened. This allows me have the necessary 'set' options pre configured etc
4 votes -
AutoComplete table joins
Have the ability to train intellisense when joining tables to learn which tables join together.
so that in the future you can just type:
"select * from employees e
left join "and intellisense gives a drop down list of related tables, which when selected writes out the table name AND join columns.
i.e.:
"select * from employees e
left join "
and intellisense suggests: "manager m on m.managerID = e.managerID"4 votes -
Improve standard filtering in Object Explorer
The standard filtering in Management Studio Object Explorer is rudimentary at best. I lack the ability to select multiple values, and use drop downs to do so. Or even better, use complex queries (with and/or/not), and maybe even save and reuse these for daily administration (much like snippets).
4 votes -
Performance when starting visual studio
When starting visual studio with SQL Complete, it takes 15 seconds more to open Visual studio.
Maybe you can change to load the data after visual studio is opened? That way the delay is not visible to the user.
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 -
Override capitalisation of certain keywords
I like to capitalise 'begin' and 'end' in lower case so my code looks like this:
IF @Return = 1
begin
SELECT Name FROM Table
end
ELSE
begin
SELECT 0
endThe begin and end words should not be as bold as the sql statements, a bit like curly brackets are.
3 votes -
Add an option to Execute Current Batch
Add an option to Execute Current Batch, similar to Execute Current Statement, but highlight and run everything between the current batch separators.
It's a feature I've seen that RedGate SQLPrompt provides and it would be useful to have the ability to run everything within the current batch without having to highlight it all first and then running the selected text.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 -
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 votes
AdminDevart
(_, Devart)
responded
Could you please provide us an example of this?
You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
code preview when hovering a tab or session in the "Documents Sessions" window
Code preview when hovering a tab or session in the "Documents Sessions" window. I often have several tabs open at once and they are all called "SQLQuery#.sql" which doesn't help. Allow me to see what code is in the tab by hovering it, or ctrl+tab or like tabing through windows or hovering windows in the taskbar in Windows.
3 votes
- Don't see your idea?