11 results found
-
Highlight Unused Variables
Declare @var1 INT, @var2 INT
SELECT @var1 = 1, @var2 = 2
SELECT @var1 [@var1]
-- @var2 should be highlighted in the declaration since its assigned value is never used.128 votes -
Document Sessions Improvements Phase 2
Thank you for implementing enhancements to the document sessions. It looks great and adds much more value. I would like to suggest couple more enhancements:
- It would be more convenient if more recent sessions would be on the top instead of the bottom
- Apply connection coloring to the document sessions. So each file name would have a background color of the connection. It would make the 2 features integrated and extremely useful.
- Have a setting to remove old sessions older than 2 months (or period specified by users)
- Fix Display connection details next to each file (as you do in…
9 votes -
Multi-select by selection of suggested objects
When joining tables I often get suggestions by SQL Complete for which tables to join. This is extremely useful and saves me a lot of time. Often times however there are multiple joins I want to make to different tables. But I can only select one join at a time. Selecting multiple suggestions with a ctrl+left click or something similar in the suggestions box would be a great addition for my workflow.
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 -
Alter Format of Generate Script > Insert #tmpTable
With in the feature "Generate Script > Insert #tmpTable", it renders the DROP TABLE after the CREATE TABLE and SELECT. In troubleshooting and R&D, however, there is value in having the temp table be retained. 90% of the time, I transform the DROP TABLE in to DROP TABLE IF EXISTS and move it to just before the CREATE TABLE.
I would like the option to either customize the rendering to fit my needs, or the option to select this alternate style of rendering in Options.
3 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 -
2 votes
-
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
- Don't see your idea?