662 results found
-
Option / Action to remove square brackets from types
I prefer types without square brackets ( INT vs [INT], for example).
If using square brackets for identifiers in the format options, there is no quick way to remove these.
My work-around is -
1. Apply Format Style option "Add/remove brackets + Remove Unnecessary brackets"
2. Format the block of code
3. Apply format Style option "Add/remove brackets + Add brackets to all identifiers"
4. Format the block of code
5. restore format Style option to original choiceIt would be nice to have a single action to do this, or to have a separate option in format styles to…
3 votes -
Smart Rename should be smarter about changing schema &table name
When renaming both the table and schema name, and a table already exists w/ the old table name but new schema name, Smart Rename errors because it does not detect this conflict and tries to first rename the table to the conflicting table name.
e.g., renaming stage.dboTable1 to dbo_stage.Table1 (and stage.Table1 already exists):EXEC sp_rename N'[stage].[dboTable1]', N'Table1', N'OBJECT' GO IF @@ERROR <> 0 SET NOEXEC ON GO ALTER SCHEMA [dbo_stage] TRANSFER [stage].[Table1] GO IF @@ERROR <> 0 SET NOEXEC ON GOwould work if script instead did this:
…ALTER SCHEMA [dbo_stage] TRANSFER [stage].[dboTable1] GO IF @@ERROR <> 0 SET NOEXEC1 vote -
Replace all inline comments with block comments
It would be really useful to be able to choose the default comment style as either inline -- or comment block /* */, and have that style be applied when executing an auto-format on the script.
See https://www.erikdarlingdata.com/sql-server/please-use-block-quotes-for-code-comments-in-your-t-sql/ for more info
17 votes -
Option to Omit Formatting of Comments
Option (such as a check box) to omit active style formatting of comment lines between /* and */. Similar to SQL Prompt formatting off/on without the added code lines.
2 votes -
Finding tabs with the same code
Hi, the possibility to sort/show tabs with the same code. Then you can delete history if you have more than one tab with the same code. This will make history smaller and faster.
7 votes -
Suggest casting to match data types in joins
In a large query, it can be a hassle to check every join to make sure the data types match up exactly (for example, nvarchar(50) <-> varchar(100)). These differences can have huge impacts on query performance in some circumstances, or lead to confusing results if data types are converted in an unexpected way. A suggestion to call out boolean statements comparing mismatched data types could be extremely useful.
3 votes -
Enable click-away from the window for the "Summarize Script" feature in SSMS
It would be really nice if I could click away from the summarize script window and scroll around in my script, or maximize the window for use on another monitor, or dock the window next to my script
2 votes -
Save Query Results / Results History
One option that would be really neat, is to have the option to save the results of a query so I can compare the two sets side by side without having to drop them into Excel. e.g. run a query, tag it for archive, then after a time run the query again. And I'd have two Results Tabs in the output window. Results and Results(0). If that could be extended to multiple results windows, it would give me a simple way to track changes over time. And lastly, if tagged, the results would restore with the tab.
2 votes -
"Re-connect" right-click menu option in Tab History
TH knows the instance and DB the tab was connected to. Often, SSMS/SQL Prompt forget upon SSMS shut-down and fire-up the next day, to reconnect. (Happened 2020-10-02, so a current problem on just 4 tabs, when I often have a dozen open).
Select one or more from any of the lists ==> right-click ==> new option to "Reconnect to saved instance-DB", or "Connect all to an Instance" (Problem with that is the default to master means we likely have to visit every tab anyway - unless RG gives us a better version of the Connect dialog! Where it connects and…
2 votes -
Find Invalid Objects not working in v10.4.2 (SSMS 18.5, 18.6)
Find Invalid Objects not working in v10.4.2 (SSMS 18.5, 18.6)
1 vote -
syntax highlight double quoted column aliases
SQL prompt doesn't offer a single quote column aliases (which is fine). The code analysis feature says :
"If aliases are standard identifiers, they do not need delimiters. If they are not, then they should be delimited by double-quotes, not single-quotes."
what would be good is if SQL prompt had an option within SSMS to highlight double quoted column aliases in another colour (purple perhaps) just to make code more readable... sometimes the sea of black is hard to read when you have long, complex case statements etc.
1 vote -
materialise temp table (from SELECT INTO)
I pick up LOTS of legacy code with SELECT INTO statements.
sometimes they are into temp tables but also in physical tables.
It would be great to be able to highlight the statement in the SQL and right-click and choose to automatically convert it into a TRUNCATE + INSERT INTO (whilst running the CREATE TABLE statement for me)
for example:
/This is the statement I start off with/
SELECT TOP 10 *
INTO dbo.example_table
FROM sys.objects/SQL prompt pops up with dialog box to choose the table name and creates the table for me/
CREATE TABLE…2 votes -
Macro Recorder
Create a plugin to record and replay keyboard commands like notepad++ or sublime.
2 votes -
'Copy as IN clause' orizzontally too
hi, i'd like to have the function 'Copy as IN clause' not only when i select data vertically but orizzontally too
1 vote -
Tab History Window Behaviour
Can the tab history window, when maximized, be made to consider the maximum screen size when it's popped out?
I have monitors that have different resolutions and if I pop it out on my smaller screen it doesn't fit and I loose the top of the screen with the search and tabs - but most annoyingly that also means I loose the window bar so can't control the size either!2 votes -
Show only column names in intellisense while doing SELECT
Its really annoying to see table names suggestions in the intellisense while typing SELECT statement. I feel its not the new feature but its the bug to be fixed.
4 votes -
Add option to choose Single/Multi-line script for INSERT and EXECUTE statements
Currently SQL Prompt inserts SQL full INSERT script or EXEC SP in multiline while it might be useful for INSERT statement, but most of the times I have to realign them into a single line. It would be good if we have the option to choose wheather to add statement in single line or multi line? and its more usefull if we have shortcut to switch the inserted statement between formats?
2 votes -
Dark mode support
Dark mode support across all red gate tools.
9 votes -
Add possibility to make snippet for "GROUP BY 'by all non-aggregated columns'"
I use GROUP BY only for 'by all non-aggregated columns' in 99% of cases. I've created snippet for GROUP BY (gb) and then I pick this option from the intellisense menu. It would be nice to have possibility to have snippet that would add these 'all non-aggregated columns' automatically most probably by adding new variable.
3 votes -
Copy as IN clause - Allow second column as ID comment
So… Copy as IN Clause. Love it, but let’s improve it. Let’s say we have the following output…
ProductID ProductDesc
1 SQL Prompt
2 SQL Search
3 SQL CompareIf we use Copy as IN Clause on the ProductID column, we get:
IN
(
1,
2,
3
)Which super…. However those IDs mean nothing to me in 6 months time when I’m now having to modify my code. What would be awesome, is if I can select both ProductID and ProductDesc, then hit Copy as IN Clause, and get the following output:
IN
(
1, -- SQL Prompt
2,…5 votes
- Don't see your idea?