715 results found
-
Copy a row selection and format into a into a 2 column output (column, value)
I would like to see the ability to copy a selected row or a number of cells in a grid, and add it to the clipboard as a transposed view of the record
with 2 columns (Column Name, Value) to allow results to be easily pasted into emails etcexample (simple result only the result values would need to be selected)
ID Name Activation Date
1234 John Smith 2018-01-14output on clipboard
ID 1234
Name John Smith
Activation Date 2018-01-043 votes -
Issue code SC003 when USE is first line
Issue code SC003 shouldn't happen if the USE statement is at the top of a SQL script.
3 votes -
Add formatting support for OFFSET and FETCH NEXT
The Format SQL command currently overlooks these keywords and they end up appended to the last line of the ORDER BY clause. Ideally, I'd like to have the option to place both OFFSET and FETCH NEXT on separate lines, aligned just like the SELECT, FROM, WHERE, and ORDER BY keywords.
3 votes -
Don't allow for aliases that match snippet acronyms
What I sometimes run into, is that a table gets an alias (by SQL prompt), that matches an acronym for a snippet. Then, whenever I'm writing out my query, while calling the table by alias, snippet manager replaces the alias with the full snippet. Which can be annoying as Ctrl-Z doesn't work.
My suggestion would be to check the snippet manager before assigning aliases and not have them overlap.
Thanks.3 votes -
DECIMAL default scale warning in Code Analysis
Would be great if SQL Prompt Code Analysis would give a warning on SQL Below:
SELECT CAST( 1.453 AS DECIMAL)
SELECT CONVERT(DECIMAL, 1.453 )3 votes -
EXEC sp without return (EXEC @Results = sp)
EXEC spwho2 without return (EXEC @Results = spwho2)
Give a warning when tsql or stored procedure has execute a stored procedure without a variable for an error to bubble up to.This is the proper way because ieven in a try catch the Exec sp_who2 won't give and error to stop the tsql from going on
3 votes -
Add rule for deprecated DATABASEPROPERTY
Add rule for deprecated DATABASEPROPERTY
3 votes -
Conditionally place ON keyword on new line if exceeds specified wrap margin
My default preference is to maintain the ON keyword without a new line. I would like to be able to CONDITIONALLY place the ON keyword on a new line if, and only if the ON keyword together with the associated ON condition exceed a configurable wrap threshold.
Example:
-- Yield this >>>>
SELECT *
FROM Person.Address
INNER JOIN Person.StateProvince
ON StateProvince.StateProvinceID=Address.StateProvinceID
-- >>>> instead ofSELECT *
FROM Person.Address
INNER JOIN Person.StateProvince ON StateProvince.StateProvinceID=Address.StateProvinceID
-- Assuming the JOIN clause exceeds the wrap length
-- <<<This is particularly useful if the "Place JOIN table on new line" is NOT selected…
3 votes -
Trimming trailing spaces in comments
It would be cool if SQL Prompt was able to remove trailing whitespaces/tabs not only for T-SQL, but also for comments.
It's not something crucial, but rather nice-to-have
3 votes -
Detect the database compatibility version
When using SQL server 2016 with a database that has it's compatibility level set to 2012, I'm still being offered auto complete options for 2016 features. e.g. string_split
SQL Prompt needs to detect the database compatibility level and adjust it's intellisense accordingly.
3 votes -
Outline for scripts
It would be very helpful if there was an outline for the script being edited. Say, a script has many "CREATE PROC"s. We could have a tree or a list or a drop-down, to view a list of CREATE PROCs and click to scroll to the section.
If a tree style is selected, this could be expanded into seconds inside each PROCs.
3 votes -
Bookmarks
Bookmarks is a feature of SSMS. But all my bookmarks are destroyed once the code is formatted. So, as SSMS' feature is not so good as I want I do suggest to implement this feature by RedGate.
3 votes -
End column guide lines
I think SSMSBoost has this feature: being able to add configurable guide lines to limit the query writing space to a specified number of characters/columns. This is very handy as I always want to keep my code narrow, within the 80-char limit. Currently, I have to install SSMSBoost for it... Could this please be added to SQL Prompt? This is probably a quick feature to implement and would be tremendously useful. Thanks.
3 votes -
prevent Prompt SQL from destroying bookmarks
If format SQL makes chnages - it destroy saved marks
This occurs even when line bookmarked line hasnt (visibly) changed
Very frushtrating3 votes -
Add option to enclose reserved words/keywords in square brackets during formatting
Currently, the "Add/remove square brackets" action is all-or-nothing. If I select "remove unnecessary," it strips brackets off columns named after reserved words (like date, user, type) because SQL Server technically allows them. However, this ruins syntax highlighting and code readability.
Please add a formatting style option to: "Enclose reserved words/keywords used as identifiers in square brackets" while still allowing the engine to remove unnecessary brackets from normal columns (e.g., changing [MyTable].[MyNormalColumn] to MyTable.MyNormalColumn but leaving/adding brackets to [date]).2 votes -
Make Coloring Sharable
Make ConnectionColoringServers.xml meant to be edited and shared in the way that allows it to be copied to other servers for centralized coloring styles. I attempted to manually edit this and share it and was told by Development that his was a feature request. Refer to Redgate Ticket #362813.
2 votes -
Option to disable Redgate Assistent Startup Check
Whenever SSMS starts, SQL Prompt checks to see whether the Redgate Assistent is available, and this takes a little while.
I would like to be able to disable this startup check in options.
There is a option available to disable it, but it is already unchecked, properly due to check startup check.. But it would be nice to be able to disable it completely, so there is no startup check2 votes -
$FILENAME$ Snippet Placeholder
It would be helpful to have a snippet placeholder called $FILENAME$ that inserts the current script filename. Many of us are using database projects with SSMS, Visual Studio Code and Visual Studio where SQL objects each have their own file in the project.
2 votes -
Do not analyze files larger than N lines
For suggestions, auto-complete, and code analysis, very large SQL scripts cause excessive latency and can crash SSMS.
Please add an option where a file that is longer than N lines will not be automatically scanned/validated.
Use-Case: Complex database build scripts, schema source files, or other scenarios where a script can be tens of thousands of lines long require me to disable SQL Prompt before opening. Failure to disable SQL Prompt results in minutes of excessive latency and the inability to move the mouse around easily, type, or take any actions. This often leads to crashes, as well, either of the…
2 votes -
phishing resistant mfa
Could you please consider adding support for phishing-resistant MFA? Currently, it is not supported.
When staff attempt to authenticate using their passkey, the application displays an error indicating that this feature is not supported. I have been in contact with Red Gate support, and they have advised me to raise this request for consideration in a future release.
2 votes
- Don't see your idea?