142 results found
-
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 -
Ability to stack Insert Column List and Value List with Columns Per Line
When formatting an Insert Statment, make the Column List and Value List Stacked with the user defining how many Columns Per Line is included before going to the next line with proper tabs and alignment.
Exampe of an insert statment being stacked with 4 colums per line in and select stacked:
INSERT INTO xTicketAudit
(LineType,OrderNbr,LineNbr,InvtID,
ImportQty,POQty,ImportUnits,Units,
SpecPrice,POPrice,LineIn,User1,
User2,User3,User4,User5,
User6,User7,User8)
SELECT 'D',xdp.OrderNbr,xdp.LineNbr,xdp.InvtID,
xdp.Qty,0,xdp.Units,'',
'','','','',
'',xdp.User3,xdp.User3,'',
'',xdp.User7,xdp.User8
FROM XTicketDetail xdp3 votes -
rename
It would be very helpful to be able to right click on a tab in SSMS and have the option to rename it.
I currently have "SSMS Tools" installed to be able to accomplish this. Would be great to have the option in SQL Complete and be able to uninstall "SSMS Tools"
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 -
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 -
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 -
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 -
Integrate SSMS with CoPilot
We have already GitHub CoPilot for Visual Studio.
Integrate please it also with SSMS. Or directly ChatGPT2 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 -
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 -
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 -
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 -
2 votes
- Don't see your idea?