270 results found
-
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 -
Dark theme for SSMS
Hi, all. I'm really enjoying using SQL Complete. One feature that's been missing from SSMS is a dark theme. There is a way to hack a "dark theme" -- by changing a setting in a configuration file, but it's incomplete; ‘Object Explorer’ and ‘Output Window’ keep their blindingly white backgrounds. Please consider adding this feature to SQL Complete. Thanks
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 -
Refactoring suggestions
I really love the refactoring features, but came across 2 things that might be addressed.
when renaming procedure variable and the same variable name is used in other SP that is called using explicit variable assignment, e.g.
EXEC dbo.otherSp @variable = @variable,
the other SP variable gets renamed as well
(e.g. rename
@variable to @newName creates
EXEC dbo.otherSp @newName = @newName
instead of
EXEC dbo.otherSp @variable = @newName)
when variable is part of an EXEC command and parameter contains assignment operator, only the variable following an assignment operator should be renamedwhen leaving table alias as it is and changing…
1 vote -
F12
По F12 объект ищется в текущей базе. Но поиск не срабатывает и падает с ошибкой если:
- В базе стоит фильтр, и обьект не может быть найден при текущем фильтре.
- Если в окне студии открыт например код процедуры - и он трактуется как некорректный, например из за того что процедура уже есть в базе, а открытый скрипт начинается с CREATE PROCEDURE... То по F12 также выпадет ошибка. Нужно вручную заменить CREATE например на ALTER, только в этом случае поиск по F12 опять сработает.
Более того, вцелом неудобно сначала по F12 делать поиск, а потом дополнительно на найденом объекте по выпадающему меню…
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 -
1 vote
-
Conditional Alias using the right letter case
In the Alias settings I can choose to use upper case, which is fine, but when I do, all my conditional aliases are also all upper case, I would prefer to keep the upper/lower casing that I specified in the condition/action cells
1 vote -
Choose Default Date For Insert/Update Statements
When auto-expanding an insert or update statement by pressing the tab key, the column list provides default values for the columns. With DateTime and DateTime2 in particular, it would be helpful to configure if you want to use the UTC datetime or the current timezone. Our company exclusively stores datetimes in UTC, so to have this default this way would be extremely helpful!
CREATE TABLE #tmp (ID INT, CreatedDateUtc DATETIME2, Name NVARCHAR(50))
INSERT INTO #tmp (ID, CreatedDateUtc, Name)
VALUES (0, SYSDATETIME(), N''); -- allow this to populate as SYSUTCDATETIME() or GETUTCDATE(), depending on DATETIME2 vs DATETIME1 vote -
Extend the 'Tabs Color' functionality to 'Edit top x rows' SSMS tab.
Extend the 'Tabs Color' functionality to 'Edit top x rows' SSMS tab.
1 vote -
Fields in Alpha Order
Add an option to expand SELECT * to allow the expansion of the fields to be ordered in the order they currently are or to have the fields listed in Alphabetical order. I work with some tables that have many, many fields and they aren't in a very logical sequence, so I end up searching for the field I want. If I could expand the SELECT * and have the fields be in alphabetical order that would help a lot.
Of course I can use Find to find the field I want, or create a snippet that lists these table…
1 vote -
Ability to insert frequently used templates without need to modify them
Let's assume, a user have about 10 most frequently used templates that do not need to be modified after they have been inserted unlike snippets.
0 votes -
Enumerate available event package names and event names in CREATE EVENT SESSION ADD EVENT
Intellisense doesn't enumerate available event package names and event names in CREATE EVENT SESSION ADD EVENT ... clause.
0 votes -
indent logical operator
In a WHERE clause, there is an option to wrap before a logical operator, but then the operator is aligned with the WHERE keyword. I'd like an option to indent logical operators in the WHERE clause, so it's clear that they are under it.
0 votes
- Don't see your idea?