141 results found
-
Format Document button enhancement, to give the ability to select Style
It would be nice if the "Format Document" / "Format Selection" toolbar buttons in SSMS had a drop-down arrow next to them (like the "Other Windows" button in the Standard Toolbar). When pressing that arrow, all available Formatting Styles would appear in order for the user to select the formatting style to use. If the button was directly pressed, the default Style would be used.
If that is difficult, it would be nice to have a separate combobox containing all Styles and use that to perform the formatting when the button is pressed.
3 votes -
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 -
Line break after SELECT only if a DISTINCT / TOP clause is used
Title says it all... Give me the option to insert a line break after SELECT only if a DISTINCT / TOP clause is used.
3 votes -
Create an option just change casing
In SQL Complete, I would love an option that lets you Format Selection but only changes the casing to what you have specified in your active profile. It would leave all other formatting as is.
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 -
Format multiple documents
In the Object Explorer of SSMS I would like the ability to format multiple documents via the context menu.
The menu item should be available for Database, Views, Programmability, Programmability/Stored Procedures and Programmability/Functions, and should format all documents in the 'folder'.3 votes -
Suggestion: Null & Not Null count on Grid aggregates
It would be really useful if the option is added to see NULL & NOT NULL Count info on the Grid aggregates info-bar along with other aggregates. This will save a lot of time in finding any null value if presents in large data result set.
3 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 -
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 -
Add column names to VALUES list for INSERT INTO statement generation
When generating the INSERT INTO statement after typing INSERT INTO [TableName] and hitting tab, it would be helpful in the VALUES list, in addition to showing the default value, if the column name was included. For example -
INSERT INTO Users
VALUES (DEFAULT /ID/, '' /FirstName/, '' /LastName/)This way, for wide tables, you don't have to count column to keep track of which column you are working with.
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 -
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 -
Enable command execution in query result pane
I very often use T-SQL to create a series of T-SQL commands to be run.
I need to ctrl-C+open new window+ctrl-V+F5 to accomplish that, and it works.
However, a nice feature would be to just be able to select the commands in the query result window, and choose "execution" from the shortcut menu, and have SQL Complete do all the additional work automagically.2 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 -
Add Troubleshooting solutions in error tooltips
Example 1:
If you are using a NOT declared variable @var1, @var1 will get underlined and there is a tooltip with the error.
On the tooltip there could be a suggestion: "add declare @var1 int".
Example 2:
If you are executing a procedure and you are missing some mandatory parameters then there could be the solution "add missing parameters" on the tooltip2 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 -
region collapse auto
I would like the options to enable such a setting that when procedures, functions, etc. are opened for editing, all regions would automatically collapse. There could also be a keyboard shortcut that collapses and expands all regions
2 votes -
2 votes
-
Extend Insert Highlight Occurences feature to show popup with column name in the values area
when typing out the values for an insert statement
SSMS should popup an infotip very much like when inserting parameter for functions in Visual studio C# code.
e.g. After typing the , (comma). SSMS should show a popup
Insert into Person.Address
(
AddressLine1
, AddressLine2
,City
,StateProvinceID
)
Values
(
,N''
,N''
,N''
, __________________________#
StateprovinceID int not NULL #
_________________________#
^ popUP
2 votes
- Don't see your idea?