663 results found
-
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 -
Allow importing of .settings file, and setting Code formatting/snippets folders and default formatting style to be done via Command line
I would like to be able to better automate our onboarding process for new developers by helping ensure their snippets folder, formatting style folder and default formatting style are correctly setup. Additionally we would like to be able to automatically import settings from UNC/source control for them. This reduces the inevitability that something is missed when trying to follow a setup guide we have to additionally maintain. Thanks!
4 votes -
DEP026, updated to work with spatial code
w.sysLocationXY.STX, should not generate an code analysis error.
2 votes -
Colors Option For Different Databases
Colors Option For Different Databases
2 votes -
Additional syntax coloring - override SSMS
So I'm not sure if this is something that SQL Prompt has the ability to do or not as far as access to SSMS.
When you customize syntax coloring in SSMS, it sees variables, tables, column names, etc all as the same thing...."Identifiers"....I would love it if I were able to specify a different coloring scheme for variables, separate from the rest of the identifiers.
2 votes -
Include BEGIN TRANSACTION with "Execute Current Statement" (Shift-F5)
While using Shift-F5 to execute the current statement, any BEGIN TRANSACTIONS above your UPDATE are ignored, running it not in a transaction.
I shouldn't use Shift-F5 probably, but it's becoming a habit and could be very expensive when forgetting to highlight-execute.2 votes -
Ignore Execution Warning on Comment
I don't want to globally turn off warnings for UPDATE or DELETE without WHERE clause, but would like an authorization text that disables the warning in a given script:
-- Currently Warns:
DELETE FROM dbo.Person-- Suggestion - comment would authorize the delete to not warn
/* Authorized */
DELETE FROM dbo.Person2 votes -
Formatting arithmetic - new lines (Apex has this)
The only edge Apex has over SQL Prompt formatting, at least for my use, is being able to organize long equations. If I am using a large number of columns for an equation, I'd like to place each new column on a new line.
1 vote -
Apply casing formatting as I type, but without the suggestions.
Currently, SQL Prompt either allows you to apply casing all at once with the Apply Casing Options, or it does it as you type if Enable Suggestions is turned on.
Please add a feature so that I can have casing applied as I type, but without the suggestions.
4 votes
- Don't see your idea?