141 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)
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 -
Add a flag to individual snippets to exclude from formatting
Sometimes we have pre-defined snippets that are already formatted in a specific way, e.g. on one line, and shouldn't get adjusted by formatting.
To support this, add a couple of checkboxes to snippets:
[x] Exclude from line-break formatting
[x] Exclude from in-line character formattingThe first would cause formatting to ignore the snippet with regards to rules that insert line breaks; the second would cause formatting to ignore the snippet wit regards to non-breaking formatting (case, spacing, etc).
Common use-case; we have a subquery that gets used a lot to find the max value in a field, and if expanded…
3 votes -
Format Block Comments
As a developer, I would like options to format Block Comments.
Each of these would be check boxes to enable/disable the feature. The last two options would have a text input box at the end to allow the user to enter the character(s)
☑Insert empty line before block comments
☑Insert empty line after block comments
☑Add border above block comments using: *
☑Add border below block comments using: *Before:
USE AdventureWorks2012
GO/* First line of a multiple-line comment.
Second line of a multiple-line comment. */SELECT * FROM HumanResources.Employee
SELECT * FROM Person.Address /*Single line comment*/
GOAfter:
…
3 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 -
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 -
3 votes
-
Allow hiding of standard columns when expanding "SELECT *" with TAB
I would be helpful to be able to hide ID or partitioning columns that may not ever be needed when selecting data. They just get in the way when expanding SELECT * but are still necessary to the table structure.
3 votes -
column lookups in MERGE statements, like in INSERT statements. Click on a column name to find the corresponding value in the VALUES area.
column lookups in MERGE statements, like in INSERT statements. Click on a column name to find the corresponding value in the VALUES area.
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 -
format json output
Add an option to format JSON output with proper indentation and line feeds
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?