SQL Prompt
Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.
If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums at https://forum.red-gate.com/categories/sql-prompt
-
Format of Valid Selected Code when there is invalid code in the script (Take 2)
Version 9.2.5.6073
I would like to request that script validation be limited to the selected text during Format SQL.This is a duplicate of a Completed feature (Bug) submitted on version 7. https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/16611622-formatting-of-valid-selected-code-when-there-is-in
I see recent comments on the original request but you may not be addressing since it is marked completed.
To Replicate:
Put 3 lines below in a new Window in SSMSSOME BAD TEXT
GO
SELECT 1 FROM dbo.PersonNow select All of Line 3 after the GO Statement. Right-click, Format SQL
Should get following error:
"Error inserting semicolons" ...
Script parsing errors:
Line 1 Col: 1…1 vote -
IF Statement block formatting is messed up
IF Statement block formatting is messed up
IF 1 = 1
BEGIN
PRINT 'DO STUFF'
ENDbecomes
IF 1 = 1 BEGIN
PRINT 'DO STUFF';
END;which is what I want...I want to leave the BEGIN END indention
1 vote -
"Save As Excel" should also be an option, like Open In Excel is..
I love Open In Excel, and I've even got it usable on a machine that doesn't have Excel installed. Thankfully you guys made SQLP so it creates the XLSX without needing Excel. That's cool, because it means I can do a fudgy workaround, setting Chrome to be my handler for XLSX files.
Because Chrome doesnt know what to do with an XLSX other than "download" it from whatever temp file you guys create it in, it means when Chrome has finished "opening/downloading" the XLSX, I can hit Chrome's "Show in Folder" option and see the XLSX file in all its…
1 vote -
"Open In Excel" should confirm if only one cell is selected
If I run a query, forget to highlight all cells, then right click the results grid and choose Open In Excel then my right click will highlight a single cell, and the exported file contains only that one data value.
I'm pretty sure 99.9% of the time this isn't what the developer wants..
SOLUTION: if only one cell is selected, SQL prompt should ask "You only selected one cell, do you actually want the whole data grid or just that one cell? [Whole Grid] [One Cell]
If it's a scalar query (only one cell result) then don't ask the question
…
1 vote -
Tab History
Tab history grows considerable with tabs that you don't care about. How about a hot key combination so that when the tab is closed it does not add it to history. Example: While holding the ctrl key down I close a tab and this prevents it from being added to history.
1 vote -
Rules around string literals as object identifiers are WRONG
Per ANSI SQL, a string of characters enclosed in apostrophes (inverted commas) is a string literal, and a string of characters enclosed in double-quotes is a delimited object identifier.
This means that the following is valid ANSI SQL:
SELECT myColumn AS mc FROM dbo.MyTable;
And the following is also valid ANSI SQL:
SELECT "myColumn" AS "mc" FROM "dbo"."MyTable";
But this is an ANSI catastrophe:
SELECT myColumn AS 'mc' FROM dbo.MyTable;
And the use of square brackets is just a weird MSSQL-only thing that should die a fast death.
In SQL Prompt, Issue code DEP021 triggers when ANSI-compliant double-quotes are used…
1 vote -
Code Navigation
On large scripts it would be very handy to be able to navigate/jump between all occurrences of a variable.
1 vote -
SQL AUTO-SYNTAX
when you insert a ssf (Select * from) you select the table and correct automatically errors like WEHRE, WERE, WEHER where the user wants to say a WHERE a logical word dictionary in which, it could be done by matching characters if all the characters written are 100% or 90% matches with word WHERE whenever is the order of the characters then autochange the text for where, This also can be matched with other KEYWORDS of SQL
1 vote -
Extend Parsing power to SQL Queries and return referenced objects
Extend current Parsing to return (if requested) all SQL objects referenced by the object being parsed (including individual SQL queries passed as a string) in addition to the existing warnings/errors:
Fully referenced object (including linkedserver where used) with used columns or parameters and CRUD+E.
Call to the "Parser" via SSMS or command-line with independent result set for the referenced objects1 vote -
STRING_AGG formatting the ORDER BY
When formatting SQL with a STRING_AGG which has a WITHIN GROUP (ORDER BY... the order by formats with extra spaces between the ORDER and the BY.
1 vote -
formatting of OVER clause
Would like to control formatting of the OVER clause. E.g I would like the complete "(Partition by ... order by ...) as xyz" on one line, but today it's overrdden by other options.
3 votes -
Spell check & Normalize variables, alias and column names
I, and I suspect many others, spend waaayyy too much time ensuring new column names, variables and aliases conform to a standard and are at least spelled correctly.
Recently I named a bunch of new table columns with the word "brokerred" in them. Whoops, the correct spelling is "brokered". I won't leave that mess in there and had to go back and clean up a bunch of code.
Also, include a list of allowed abbreviations. i.e. Qty for Quantity and flag when the full word is used instead of the abbreviations. Having both "QtyReleased" and "QuantityReleased" sprinkled around an application…
1 vote -
Autoconnect Servers in Object Explorer.
A great feature would able to setup a list of serveres in SQL Prompt options.
And every time SSMS starts, it connects automatically to this list of serveres.
I spend a lot of time connecting to servers every morning, instead of them being there right away..1 vote -
MS_Description should be copyable in tooltip
Should be nice to be able to copy the MS_Description from the tooltip, since we store there explication for enum values and sometime formulas
1 vote -
1 vote
-
SQL Prompt -> Tab History -> add datetime stamp column
Currently it shows the filename and servername, but it would really help to have the datetime of when it was executed. Sorting the columns would be an added benefit as well.
1 vote -
Create boiler-plate stored procs for MS_Description maintenance and distribute to all SQL Prompt users.
Create and distribute boiler-plate stored procs that can be deployed to *all* db owners using RedGate tools that can enable developers to better create and maintain MS_Description metadata on server objects. These stored procs should automatically abstract over existing system procs and *update or add* the MS_Description metadata. DB owners having these procs from a trusted partner like RedGate will enable them to better enforce the addition, maintenance, and usage of MS_Description metadata in SQL server databases. MS_Description is highly underutilized in industry, and this is a step to increase the utilization of said resource.
1 vote -
Improve the "Open in Excel" context menu entry by preserving the data values
Probably under the wrong category as I didn't see a related option for Excel, but bit values such as 1 and 0 should be preserved as such. Decimal values such as 12.000 should not have trailing zeroes truncated. And the most rage-inducing is NULL becoming an empty cell on a spreadsheet.
1 vote -
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 )1 vote -
Intellisense filter
When getting intellisense suggestions I often want to ignore suggestions from certain schemas and certain objects, just like the sys schema is ignored unless explicitly specified. These suggestions i want to ignore is based on either a fully qualified schema or a prefix of a schema or object name.
It would be helpful to be able to specify a custom set of "hidden" objects that only shows if explicitly requested (by specifying the schema or full prefix).
3 votes
- Don't see your idea?