663 results found
-
Allow custom rules for code analysis
SQL Prompt has the ability to catch and warn about Update statements without Where clauses.
How about something similar that catches and warns about security commands like Grant or Deny.
8 votes -
SSMS - object list - filter from clipboard
In the right-click menu of the "Tables" branch in SSMS, create an extra item that would retrieve string from system clipboard and apply it as an object name filter (using the SSMS built-in [Filter] => [Filter settings] => [Name] => [Contains] feature).
This would allow for instant filtering, saving lot of time.
2 votes -
align aliases
Please, separate options to align aliases for columns and tables..... I love aligned column aliases, but table aliases advance too far right, unnecessarily.
8 votes -
Make Ctrl-Y repeat last action
I use actions (from the ctrl menu) a lot. It would be extremely handy if I could re-do last action on the currently selected text by simply hitting Ctrl-Y (rather than hitting Ctrl and selecting it from the list of actions again and again).
2 votes -
Make a
Similar to visual studio code, it would be good to have a find and replace all occurrences by highlighting what you would like to replace. This would then give you the option to type in what you want to replace. I know Sql Server has a find and replace function, however I just really like this functionality and think it would be a great addition to SQL prompt
1 vote -
1 vote
-
More Casing/Capitalization Options
Regardless of the source table, we would like the option to force table, column, and alias names to lower case. (We integrate databases from multiple sources and our queries look like a mess when half of the columns are upper case and half are lower).
Example:
SELECT dp.PROJID AS cpprojid,
pld.suffix AS projectsegment,
IP.projectnumber AS innprojid
FROM DEL.PROJ AS dp
INNER JOIN DEL.viewprojectlvldetail AS pld
ON pld.PROJID = dp.projid
LEFT OUTER JOIN inn.PROJ AS IP
ON dp.PROJID LIKE IP.cpproj_id + '%'I think this is hard…
7 votes -
Make semi-colon optional at END(;)
Semi-colons are automatically added at every END reserved key word. Make this optional.
END(;)
END TRY(;)
END CATCH(;)This just look weird to everyone
BEGIN
....
END(;) <=== don't want it here... there's an ELSE continuation.
ELSE
BEGIN
END(;)1 vote -
Ability to format SQL text externally
It would be nice to have ability to format the documents automatically, have an API or command line command for that. For example to force format when check-in code.
11 votes -
Do not consider code flagged for no formatting when formatting.
If I have a very large script with the majority of it with formatting disabled, or even with just a highlighted small area... the ctrl-K,ctrl-Y formatting seems to consider the parts it will not be formatting. Example: code in a separate window will format instantly while in a window with 100k lines with same code highlighted it will take a long while. This seems to indicate that it is considering all of the code even though it is only formatting a small piece.
2 votes -
Management Studio 18.0 Support
SSMS 18.0 support, the latest till now, doesn't support ssms 18 preview 4
5 votes -
Autocomplete WHERE clauses with variables
It would be neat if WHERE clauses could get autocomplete suggestions with declared variables (or variables that are procedure parameters). Example:
Assume Table1 with one column Column1.
DECLARE @Column1
SELECT *
FROM Table1 T
WHERE T.Column1 = (suggest @Column1, any variable that exactly matches column by name, except @)2 votes -
Automatic Alias from Table Name
(5 previous votes)
Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.
eg.
Customer = C
mem_Membership = Mcus_StateCustomer = SC
aReallyLongTableName = RLTN
view_CustomerMembership = CM
4 votes -
AND keyword for WHERE and JOINs on new line
There is no option in CLAUSES > JOIN to place AND on new line (Right aligned to INNER) and in Data (DML) there isn't an option to put AND on new line. Lots of tables I join on I am joining on 2 columns and I prefer to have the AND a.col1 = b.col1 on a new line as well.
4 votes -
move options settable under "SSMS > SQL Prompt > Options > Format > Style" page out of the Settings file and [back] into Style file
In version 7 the Style option FormatActionRemoveSquareBrackets was removed from the .sqlpromptstyle Style file into the .settings Settings file. I would like it moved back into the Style file, along with all other Style options settable under "SSMS > SQL Prompt > Options > Format > Style". See https://productsupport.red-gate.com/hc/en-us/requests/122489 for additional details.
2 votes -
Script Temporary Table Declaration from Query
Context menu item to take the current query under the cursor and script out an appropriate DECLARE @table or CREATE TABLE #table to match the names and types output from the query.
6 votes -
Warn before running code that might fire trigger
SQL Prompt gives me a warning when I execute a query or batch that would truncate a table or that includes an update or delete without where clause.
Is it possible to get a similar warning when I execute a query or batch that runs an insert, update, delete, or merge statement against a table or view that has a trigger? (ideally the warning would only fire if the trigger is not deactivated, and if it is for the correct operation)12 votes -
Add option to exclude placeholder or escape it.
I have text within a snippet which includes the string "$2a$". The snippet manager replaces this which is not what I want. I need the snippet to remain unchanged.
2 votes -
Add option to indent code between BEGIN TRANSACTION and COMMIT TRANSACTION
Someone else has submitted this suggestion and it is marked completed. However, it does not seem to do so in my version of SQL Prompt (9.2.6.6145)
9 votes -
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…5 votes
- Don't see your idea?