272 results found
-
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 -
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 -
3 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 -
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 -
When a single quote is entered, add a trailing quote. And prefix leading single-quote with a N if field is unicode. Move insertion point
When a single quote is entered, add a trailing quote and prefix the leading quote with an N if equality with a Unicode value can be inferred. Move insertion point between the quotes.
7 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 -
INSERT INTO expansion
When you type "insert into table(" popup with check-boxes shows up. After you select desired columns you have to add 'values' part manually.
It would be nice if after selection of desired columns and typing ")" 'values' part shows up with preset only for selected columns.
2 votes -
Display column level extended properties if available in another column on intellisense popup
I see table description extended properties displaying, but no details on the column description. I'd like this to be an option, so if a business uses this for documentation, you could easily look at the column definitions while using the intellisense suggestion list.
1 vote -
Go to definition - Add compatibility for filters
The feature to go to the definition of an object in the object explorer currently does not support filters. If that subsection is filtered where the object should be, it will give an error instead of removing/changing the filter and locating it.
1 vote -
Cache suggestions between executions of SQL Server Management Studio
Most of the time, the schema does not change when I connect to the server via SSMS. It would be nice if the auto suggestion cache would maintain itself between executions of SSMS, and only update the parts which are different from the last time. This would make the startup experience faster over slower links (like VPN) to the server. It also would help with databases that have a large number of objects.
1 vote -
Format declare statement with assignment from select statement eg DECLARE @sourceTrackId int = (SELECT Id FROM Track t WHERE t.TrackCod
Declare with select assignment does not format very well.
DECLARE @sourceTrackId int = (SELECT
Id
FROM Track t
WHERE t.TrackCode = @sourceTrackCode)1 vote
AdminDevart
(_, Devart)
responded
Could you please send us the screenshots of the actual and expected results to our support system at supportATdevartDOTcom for investigation?
-
Quick/favourite Connections
A popup that list recently used/pinned servers-database
allowing for 1-click switch to that database while writing your query.
A shortcut key for this would be appreciated.The Current default SSMS behaviour > Select a server then select a database then continue working. sometimes ones default database is set to master/orsomedb which is inconveinient and always has to switch.
19 votes
- Don't see your idea?