638 results found
-
Allow tab history to stay open
I want to be able to keep my tab history open. I am rebuilding a lost development database and using search a LOT, but after I search, find a tab I want to look at more deeply or execute, the window disappears and my search predicate and place in the list of matching tabs is lost, so I have to enter search predicate and scroll back down each time. This is a VERY useful tool, but it would be so much more useful if I could just keep it open.
16 votes -
Show last known value of T-SQL variables in pop-up definition
If I declare variables and assign them values (either in declaration or subsequent SET/SELECT statement, it would be very helpful if SQL Prompt, along with displaying the declaration (e.g. @MyVar int (Scalar variable) in the pop-up, would display the last know value. So, if my declaration was:
DECLARE @MyVar INT = 123
the popup would show something like @MyVar int = 123 (Scalar variable).
I realize some might be rather long (string) or not displayable at all (e.g. table variables, cursors, etc.) but what appropriate showing the value that was set and last known could be very helpful in line…2 votes -
Generate a meaningful filename when clicking 'Save' in SSMS
When you open up new queries in SSMS they are always called SQLQuery1.sql , SQLQuery2.sql etc. etc.
what would be useful is if SQL prompt generates a more useful filename when you click Save or Save As in SSMS.
For example,
Say I had the script:
CREATE VIEW report.vwRandomName
as
SELECT *
FROM TableAwhen I clicked save, it would replace SQLQuery1.sql with
report.vw_RandomName.View.Create.sql
and the same with other object types (table/stored procs etc) and other actions (create / alter / drop).
thanks
ben2 votes -
Ability to run Code Analysis against whole DB
With the deprecation of SQL Code Guard and it's replacement by Code Analysis there is one feature that we heavily used that is now no longer there, and that is the ability to run SQL Code Guard against the whole DB not just the query on the screen.
This allowed us to investigate new DBs that we'd inherited to see what sort of cleanup we might be looking at as well as giving us the ability to see if anything had snuck in to our existing DBs without going file by file.
I know there are other tools (like SQL…
16 votes -
Additional Formatting Options
These are the typical formatting styles I use that I would like to see definable in SQL Prompt. Currently, I use a style that gets me close then manually format the remainder to the code:
Regarding the desired format of
1) SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY all lined up
2) TAB after SELECT, followed by first 'column'
3) Subsequent columns on separate lines and lined up with the first one.
4) TAB after any CASE followed by first WHEN
5) Subsequent WHENs lined up with first one
6) TAB before THEN (i.e. indented one tab from…4 votes -
SQL Prompt Code Visualization (Like Flow Chart)
SQL Prompt should be able to Visualize the Code and represent the code like Flow Chart.
This Feature will be very useful while working with heavy Stored Procedures.The Sample Code Visualization image is shared below:
https://drive.google.com/file/d/1dE0H7UP1MOuOZ4A3e4urUkDlR0FD4474/view?usp=sharing
21 votes -
Add option to wrap lines when concatenating strings
Sometimes I set a variable equal to many strings concatenated together using the "+" syntax. When I format with Regdate, there is no option to wrap lines in this case. Everything ends up on the same line as the SET, so the lines often get very wide and go off screen.
It would be great if there was an option to wrap text if things got too wide horizontally.
One solution would be a setting to format concatenated strings like this:
SET @Variable = N'String1'
+ N'String2'
+ N'String3'4 votesHi Amanda,
Would the ‘wrap lines longer than X characters’ option in the formatting styles help with this?
Tim
-
Add context menu shortcuts to SQL Prompt context menu entries
I want to be able to quickly switch between active styles.
I'm informed that the solution to this was to add the Active Styles section of the context menu, to allow quick access to the active styles.
That's fine as far as it goes, but that entry is very far down the menu and is only quickly accessible by mouse.I would like to suggest having the "Active Styles" entry changed to "&Active Styles" so that the A becomes a shortcut in the context menu; and to have each of the styles listed as &1, &2, &3 etc. in the…
1 vote -
Is there a way to run your code analysis rules against an existing database?
To help our developers we - as dba's - perform validation against their procedures and database code. The library of rules that is incorporated in SQLPrompt could be a good rule of thumb for the basic stuff of reviewing, so that we can focus on other stuff when validating.
Is it possible to run the rules "engine" of SQLPrompt against an existing database without having to open the code manually?3 votes -
Run Script at Cursor
Run Script at Cursor just Oracle SQL Developer with F5 or Alt+X. Please implement this very helpful functionality.
1 vote -
COLUMNPROPERTY
COLUMNPROPERTY (https://docs.microsoft.com/en-us/sql/t-sql/functions/columnproperty-transact-sql) is missing two suggested property values that were introduced along with System-Versioned tables in SQL Server 2016.
Please find the missing values below:
GeneratedAlwaysType
IsHidden1 vote -
Allow Copy/Paste contents of 'List of Code Analysis Issues' window.
Sometimes I would like to just copy/paste the issues discovered and include in an email. Currently, I cannot copy the Issues list. It takes too much time/effort to export to a file and then attach that file to an email. Copy/paste would be so much easier.
2 votes -
compare datatypes in stored procedure calls with defined variables
When I call a stored procedure, I want SQL Prompt's code analysis rules to be able to tell me if the variables I am passing to the stored procedure are OK.
For example, if I pass a bigint variable to a SP that has a tinyint input parameter, I want SQL prompt to flag that as a potential issue.
Similarly, if I am passing a string variable defined locally as nvarchar(150) to a SP that takes only nvarchar(100), it should be flagged as an issue (because I am passing a string that may not "fit" into the input parameter).
3 votes -
add trigger definition to a triggers tab on object definition box
Currently, when hovering over table objects, and clicking on the table name mini popup, you get the object definition box, with a 'Script' and 'Summary' tab.
The 'Script' tab has the table and index creation scripts, and the 'Summary' tab lists the column definitions.
For tables with triggers, it would be nice to have a 'Triggers' tab that contains
any trigger scripts for the table.1 vote -
Top with parenthesis should be a formatting option
Changing
SELECT TOP 10...
to
SELECT TOP (10)... should be a formatting option.
11 votes -
Allow query results to be editable grid
I would like to have the ability when using Redgate to develop a query as I do today in a new query window with all the object search and suggestions features currently offered in your product.
After I get the query returning the correct record set, I want to be able to edit the record set without having to copy the query and navigate to SSMS’s “Edit Top XXX Rows” menu item.
Editing a field on the row would update that field on that row when I move off the row.2 votes -
Make warning settings environment-specific
Hi RedGate Folks,
I think it would be helpful if the execution warnings settings were environment-specific. I.e., in the color coding section, we can establish which connections are prod, test, dev, etc. It would be great if I could -- for instance -- turn on warnings for DROP statements in my prod environment only.
2 votes -
Vertically align option for concatenated strings
When concatenating strings, it'd be nice to be able to align the "+" sign. The following is what I get now:
SELECT CASE
WHEN Col = 1
THEN 'Col 1'
ELSE ''
END + CASE
WHEN Col = 2
THEN 'Col 2'
ELSE ''
END + CASE
WHEN Col = 3
THEN 'Col 3'
ELSE ''
END + CASE
WHEN Col = 4
THEN 'Col 4'
ELSE ''
END AS ConcatStr
FROM #Test;But what I'd like to get is:
SELECT CASE
WHEN Col = 1
THEN 'Col 1'
ELSE ''
END
+ CASE
WHEN Col = 2
THEN 'Col…1 vote -
Include auto fix for single quote string literals as aliases warning, Issue code: DEP01.
Create auto fix for Issue code: DEP01 non-standard column aliases because of single quote delimiter. Also need to update SQL Format tool, it is currently using single quote and there is no way I could find to switch it to double quote.
2 votes -
Improve Autocomple
After Update to 10.0.
When you for example press J for join and confirm this input with Tab, it wont add a Space. You have to add this space manually :(
maybe it is possible to add automatily always the space1 vote
- Don't see your idea?