158 results found
-
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 -
Filter on the toolbar for filtering on all objects. To work in real time as you type. Current filter process is painful
Filter on the toolbar for filtering on all objects. To work in real time as you type. Current filter process is painful.
Imagine I want to filter SP's, tables, views based on the string 'pack', for stuff like 'vwpackingtray' and 'sppackStrut'. At the moment I have to go to each object type area individually, open a poorly designed dialog, select focus before typing (?), type in the search term and save.
I want a filter textbox in the toolbar, and as I type in it, the objects across the whole database(s) start to filter down to…
1 vote -
Alias CTE like tables
When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue
0 votes -
Fast way to open objects (stored procedure) sql create definition
Shortcut (Shift+Alt+O) to open an window with the names of all database objects (stored procedures, tables) and a textbox to enter the name (partial, multipart) of the object to find. While typing remove non matched names from the list. When selecting an object open a menu with options like Script Object AS (CREATE, INSERT etc).
Then open a new SQL Server Management Studio window with the selected SQL code.1 vote -
Virtual Folders for Database Objects In SSMS
The ability to add folders in SSMS for database objects. I understand these folders would only be virtual.
I know of one addin that has this feature. www.sqltreeo.com
43 votes -
While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or
While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or to browse to the object.
1 vote -
in visual studio, right click on table to select top 1000 rows
in the ssms object explorer, many of us regularly right click on tables to select top 1000 rows, which opens a new query window with an editable query script. visual studio's sql object explorer has no such functionality besides view data which forces you into a designer-based edit mode.
11 votes -
unwrap
I love the "format document" and "format selection" features and would be interested in a "unwrap document" and "unwrap selection" feature.
I use Notepad++ to do it currently but it is required when trying to paste SQL Code in Visual Studio.
All it does is turn the code into 1 line...
Thanks
Yann2 votes -
Ability to copy a value in the grid along with the column it belongs and formatted for WHERE clause
For example, let's assume this is the output from a query:
id name role
1 Torn ADMIN
2 John CLERK
3 Adam SUPERI would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.
In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
name = 'Adam' and role = 'SUPER'16 votes -
insert into table set param
when type insert into table then type Tab can get result like bellow
Declare @SerNo XXX(SerNo RealType)
Declare @NameXXX(NameRealType)
Declare @ValueXXX(ValueRealType)
insert into TestTable (SerNo,Name,Value)values(@SerNo,@Name,Value)it's real help for me
1 vote -
Autocomplete picklist wider
If would be great if the autocomplete pick list was resized sqlcomplete would remember this size change.
4 votes -
Remove square brackets
Microsoft's SQL Server Management Studio puts square brackets [ and ] around everything scripted or dragged/dropped from the Object Explorer to the scripting window.
I want a feature to remove all square brackets.
I currently have to use SQL Management Studio search/replace to remove the brackets, and rather have the removal performed when I format the code.
Jake
73 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 -
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 -
Format wrapped SET Statements with indentation
When a SET statement is a series of concatenated strings and you wrap the elements, the formatter aligns the wrapped strings with the SET keyword. They should have an option to be indented. Note below that periods denote indentation.:
SET @Foo = @Bar + " some text " + @Baz +
......." some more text";Is formatted as:
SET @Foo = @Bar + " some text " + @Baz +
" some more text";Note that the indentation on the wrapped line is removed. It would be nice to have an option that results in:
SET @Foo = @Bar +…
1 vote -
Add new Forrmatter settings
Issue: Formatter, add the ability to configure segment FROM represented JOIN in tabular form.
Example: http://www.sql.ru/forum/actualutils.aspx?action=gotomsg&tid=976629&msg=162244751 vote -
Creating relation mappings for databases that may not be changed
In our company we are working with SAP Business One (SBO). SBO has a fixed database stucture which may not be changed at all. Relations are not directly built into the database.
A custom relation mapping feature would help us with correct suggestions for the databases while still maintaining the database structure as it is.
3 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
- Don't see your idea?