140 results found
-
Sync user settings and snippets across machines
Sync settings and snippets across machines.
For example, if I create an custom snippet on my laptop, then shift to my desktop, the snippet would sync'd to my desktop automatically
1 vote -
Can write a label to any tab
I click new New Query, then a new Tab open, I wrote my code, then I click again New Query and other Tab open, so I dont want to save to disk this tabs, but I would like to rename and put a label on each so if I have 10 Tabs opened, I can identify quickly for the tittle each one.
1 vote -
Alias generation new rules
Hello,
I would like to get new options for alias generation that are not based on first letters of the object name but more on parts of the name itself.
I work with a database that uses the following name standard: T{1}{222}tablename where {1} equals the type and {222} equals the unique trigram for the table (ie: TRCUScustomer for customers table, R being a reference type). I would like the alias to use the {222} part of the name (so "cus" in this case).
So a new rule such as "T*{3}*" where the 3…1 vote -
TEST MODE
There should be a toggle-button that flips between a TEST mode and a production mode for your "code/code window"... And when its in TEST mode, whatever code is there, BEFORE it is executed, is WRAPPED in a Transaction AND rolled-Back.
APEX SQL has this feature, trying to switch to Devart, and missing it.
1 vote -
compare
add feature to compare 2 open tabs in management studio, or compare 2 code objects from different db's to see the changes highlighted
1 vote -
Spelling check of the comments and optionally in variables, column names, etc
It is very common to make typos or spell words incorrectly as you code or write comments. It would be nice to introduce a spelling check of the comments and optionally in variables, column names, table names, procs, functions similarly how it is done in PyCharm.
That is especially useful when you create new tables. If you misspell a column name it is such a pain to fix it later.
1 vote -
Extract to a function or a procedure
By selecting a portion of the code in a stored procedure, giving the ability to create a new stored procedure or function from that code.
All variables present in the selected code are automatically passed as parameters. The selected code is then replace by a call to the function/procedure
This will help to divide the code in sub function and been auto documented.
1 vote -
Higlight Case errors
Like Microsoft's IntellySense does, when you open or write a script, case errors in variable names, table names, and field names are underlined in red (higlight) as a warning and can be corrected if desired.
This funcionality is like a spell checker.
You currently open a script and SQLComplete is not able to tell you what case errors there are.
This is quite important in environments where this requirement is required to be met.1 vote -
Add context menu item "Copy to new window" to Results window
I often use SQL to generate SQL commands based on information from sys tables. This enables me to keep things in sync.
Currently I need to Ctrl-C my selection, open a new tab, Ctrl-V in it, and then hit F5.
A context menu item, that does all this (except F5) would be a nice addition.1 vote -
Persist column layout in Execution History
The execution history is a great feature. It can be made more using if SQL Complete was able to persist column changes (moves or exclusions). Currently, the end user is able to move the columns, for example, move the Server column to the left or right. The end user can also remove unwanted columns. However if you close SSMS and reopen, the columns are back to their original positions. This is not very user friendly as the purpose of a user changing the column layout is to have it displayed the way they want.
1 vote -
Email notification when query completes
I previously used SSMSBoost. There was a feature, Query Post-Execution Handlers, that included Results per Email as an option. This feature leveraged PowerShell as the engine, perhaps because it was a Windows installation, and a "script generator" dialog box that converted selected options and variables into a PowerShell script and email message. I would have added a screen capture of this interface, but this post won't accept attachments. The feature also accepted a threshold so it would only apply to queries that exceed a specified number of seconds. It was nice to be able to set this up for long…
1 vote -
NewID() Snippet
I want to create a snippet that will generate a new guid value (the actual value generated from NewId()).
1 vote -
Document sessions
Enhanced Documents Sessions
The main issue I have with SQL Management studio is managing all the tabs and code. One great feature would be the ability to automatically group all sessions by the active database. A modern approach would be to have "grouping" tabs, where you can place code, or a tree approach with subtrees.
The single biggest issue I have is editing stored procedures/functions. If you multiple tabs with the same proc and edit one, then open the other tab and edit by mistake, it is a disaster. Being able to label a session with the actual stored proc…
1 vote -
Color brackets.
Please add the ability to color brackets. Just like it happens in Excel, for example, when you write a function. The opening and closing brackets are marked in one color.
1 vote -
editing single instance Stored Procedures
An option to only allow editing a single instance of a Stored Procedure, Function, etc. (and perhaps the name in the tab or top of file). Or at least a warning if this procedure is already open in another tab.
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 -
Formatting option for BACKUP/RESTORE commands
I like BACKUP/RESTORE commands formatted so that all the options (especially MOVE options) are on separate lines in order to enhance readability.
0 votes -
If user types a paren *immediately before* a paren, skip *past* the paren instead
AutoComplete suggestion: MS Visual Studio does this, you should too.
- Type in a function name: SQLComplete adds a full set of parentheses: SET X=myFunction()
- Type in function parameters: SET x = MyFunction(1,2)
- If user types closing paren, we have two, which is wrong. Current alternative is to right arrow or something to get past it.
- SUGGESTION: If user types a paren immediately before a paren, skip past the paren instead!
MS Visual Studio does this and it works great.
0 votes -
Expand contect menu "Generate Script As" with an "As-Is" option.
This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.0 votes -
Standard color for inactive tabs
With the tab coloring feature, it can be difficult to tell which tab is the currently active tab just by looking at them. Some of the colors of the disabled tabs come through as slightly different than when they are active, but look like they might be active because they are close to other colors.
I would suggest either making all inactive tabs gray, or to introduce some other type of visual queue to help easily distinguish active from inactive tabs.
I can't upload a screenshot here but I do have one as an example.
0 votes
- Don't see your idea?