689 results found
-
Align BETWEEN with comparison operators
It's currently possible to align operations in WHERE which is great, but BETWEEN is not aligned.
Example - currently:
WHEREModifiedDate BETWEEN DATEADD(MONTH, -6, GETDATE()) AND GETDATE()
AND City__________= 'Bothell'
OR LEFT(PostalCode, 2)= 'CB'
OR PostalCode_______= @prefix + @suffixExpected:
Example - currently:
WHEREModifiedDate_BETWEEN DATEADD(MONTH, -6, GETDATE()) AND GETDATE()
AND City________= 'Bothell'
OR LEFT(PostalCode, 2)= 'CB'
OR PostalCode_______= @prefix + @suffix3 votes -
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 -
wrap line at the limit, not at comma
When setting a line wrap at a number of cheracters, I would like to get the line at that long, and then wrapped. Not at the first comma. For example currently I get:
select firstname
, lastname
, email
, phonenumber
, country
, countryalias
, region
, gender... but I want to get:
select firstname, lastname, email, phonenumber, country
, countryalias, region, gender1 vote -
Make equals signs line up with tabs
When I type code I like to line up all the equals (=) signs using tabs so that all the code to the right of the equals sign lines up nicely on my screen. I find this really useful for improving readability when using column aliases, in joins, and in update statements.
I can't find an option in SQL Prompt to do this and it annoys me when I format my SQL and all the equals signs become ragged.2 votes -
Autofix for existing functionality
There are cases where the code analysis detects errors and where the tool already have functionality to correct the issue. For instance with unqualified column names
2 votes -
List aggregate functions before system fields
When putting a COUNT in a select field, the default option in intellisense is sysxmitbody.count. I understand if I have a field that contains the aggregate name in my table that you suggest it first, but I never want sysxmitbody.count - and if I do, I'd expect to go looking for it.
I feel like I've hit this problem with other aggregates as well, but can't find another example at the moment.
Not sure the best fix, maybe list all system tables after user tables and functions?
2 votes -
Support a personal library of full queries with named parameters
This idea is kind of between snippets and tab history.
USE CASE
I frequently need to diagnose issues with our data. This typically involves using on of a few dozen queries. Currently each time I need one of these I have to 1) check to see if I have a recent version in tab history; 2) load it from some .sql file I happened to have saved it; or 3) rewrite it from scratch. For 1 and 2 I then have to search for all of the places where I need to replace WHERE expression values with data specific to…1 vote -
Object preview tab size too big - SSMS uses 4 space tab, preview using 8 space tab
When hovering over an object name to view its contents...the tab size used in the code is much larger than what is being used in SSMS. So the formatting of the preview is completely messed up.
Maybe a setting to configure the tab size? Or maybe it can look up what SSMS is using?
1 vote -
Custom Warnings in SQL promt
Custom Warnings.
For example, we have juniors who are just starting out in the SQL server world, Id like to have warning for Select statements that do not have Nolock hints. As the juniors will never be running any updates and deletes, they only have read access, but currently sometimes people forget the nolock hints and start causing locks and so on.5 votes -
Allow me to specify relationships
I'd like to be able to give hints about how to join two tables. For example, column A in table 1 is the key for column B in table 2. It's not always possible to make that a real reference column so it would be nice if SQL Prompt knew that it should present it as an option when doing a JOIN clause.
2 votes -
Replace synonym with target object
I would really like the option to select the occurrence of a synonym in DML statement and have SQL Prompt replace it with the synonym's target object.
2 votes -
Azure SQL Database Smart Rename support
Smart rename doesn't work on Azure SQL Database without creating a SQL login to use for the task. Be nice to support connections via Active Directory Password, or any of the other Azure AD auth options.
3 votes -
Prefixes in function parameters
SQL Prompt is removing prefixes from column names used as parameters in function-calls. For example, if you use Cross Apply to a system function:
SELECT *
FROM sys.tables AS T
CROSS APPLY sys.fnlistextendedproperty('blah','schema',schemaname(T.schemaid), 'table', T.name, null, null)
It removes "T." from schemaid and name in the parameters list. This means I have to add them back in if the column names are ambiguous. I don't see a setting for this, and have Prompt set to add prefixes to columns in the other clauses. So it'll add "T." to a column in the Select clause, and remove…4 votes -
Comment in /* */
Is it possible to add a hard return after the /* comment */ block so code doesn't keep formatting after the comment
Currently:
/* comment */ UPDATE User
SET Modified = CAST('2018-12-20' AS datetime)
WHERE id = 255454Suggestion
/* comment */
UPDATE USER
SET Modified = CAST('2018-12-20' AS datetime)
WHERE id = 2554545 votes -
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-042 votes -
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 -
filter snippets between default and custom
Ability to easily identify user-created snippets from default Redgate snippets.
I love snippets and I create a ton of them, but there's no easy way for me to filter the list of snippets to see which ones I created vs the ones that shipped with the product. I'd love the ability to be able to filter the list of snippets to show my custom snippets so I can find them easily.
(My work around is just to use a naming convention that groups them all, but this feels inefficient because it requires that I type more letters to activate the…
3 votes -
Copy & Paste into temp table
I often need to work with data sets from Excel. Instead of doing a whole "Import Data" process I would like to copy from Excel & paste into SQL Management as a temp or persisted table.
1 vote -
Add a "Copy Filename" and "Copy Filename and Path" option to Tab History
There are times when want to be able to reference a specific file name in, for example, bug reports. This option is to allow the selected filename (or filename with path) to be copied so that is can be pasted into other documentation.
2 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
- Don't see your idea?