156 results found
-
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 -
column alias
I would like an option for column aliases. I would like to choose between = or AS for the "Alias sign".
The formatting should be done based on this "alias sign" and also be aligned by the alias sign.I prefer the = sign , but formatting doesn't seem to accept that as an alias now.
Example before formatting:
SELECT colA as [Column A], columnB as [ColumnLonger B]
FROM Table_1 tFormatting when "=" is used as "Alias sign";
SELECT [Column A] = t.colA
,[ColumnLonger B] = t.columnB
FROM Table_1 tFormatting when "AS" is used as "Alias sign":
SELECT…
6 votes -
Global Refactor (rename) tables/views/procs in dependent views/procs
SQL Complete has an option to do renames within the current script. It would be great to support refactoring (rename) tables/views/procs/functions in dependent views/procs/funtions.
For instance:
CREATE TABLE dbo.Test (a INT, b INT, CONSTRAINT [PKdboTest] PRIMARY KEY (a))
GOCREATE VIEW dbo.vwTest
AS
SELECT * FROM dbo.Test
GOCREATE PROC dbo.spUpdateTest
(
@a int,
@b int
)
as
UPDATE dbo.Test
SET b = @b
WHERE a = @a
GOOn a separate screen (or from SSMS object explorer) choose refactor and change table name from "dbo.Test" to "dbo.GoodTableName" and SQL Complete would identify all objects where dbo.Test is…
6 votes -
Force capital word
There are some identifiers and variables we'd like to force with CAPTITALS regardless of the formatting rules.
Similar to the "General > Available prefixes:", could we have a "Force word formatting" option where we can enter these special word types? ie. TranSid ==> TRANSID
6 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 -
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 -
add a shortcut to do a "edit top 200 rows" on a selected SQL sql statement
Add a shortcut in the context menu to do a "edit top 200 rows" on a selected SQL sql statement
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 -
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 -
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 -
Autocomplete picklist wider
If would be great if the autocomplete pick list was resized sqlcomplete would remember this size change.
4 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…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 -
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 -
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 -
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 -
Smarter subquery intellisense
It would be nice to have smarter subquery intellisense that works like the joining intellisense that suggest matches based on column names.
E.g.
SELECT * FROM Users WHERE EXISTS (SELECT 1 FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID AND UserRoles.RoleID = 1)E.g.2
E.g.
SELECT UserID, UserName, (SELECT COUNT(1) FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID) AS NumberOfRoles FROM Users3 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 votesAdminDevart (_, Devart) respondedCould you please provide us an example of this?
You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
- Don't see your idea?