638 results found
-
Azure SQL Intellisense....please!
I do not see Intellisense for AZURE sql. Please, please, please. There's code formatting, but no actual intellisense like ssms.
10 votes -
SQL Prompt Connection Options
SQL Prompt doesn't allow to exclude servers, only way we can filter out server if we add each database under SQL prompt settings (Suggestions>Connections).
We have busy production server and if we connect to production server, SQL prompt execute series of SQL queries against system database tables. Even though impact is minimal, It would be nice if there is a way filtering out servers rather than just the database objects.
1 vote -
Support for Synapse Serverless / On-Demand
Please add support for Synapse Serverless Databases for Intellisense!
15 votes -
do a tab between the comma and the field and indent it all one tab
Add option to do a tab between the comma and the field and indent it all one tab with the first line double tabbed to keep in line with other fields.
Please see also see forum discussion: https://forum.red-gate.com/discussion/comment/1679921 vote -
Where clause should suggest column first, then variable
When typing in a where clause, the column name should be suggested first, then the variable.
1 vote -
Allow SQL PROMPT to resolve constants in an ORDER BY clause
If I create a query with an ORDER BY clause such as ORDER BY 1, 2; SQL Prompt will flag the ORDER BY and report ORDER BY clause with constants.
It would be nice to have an option to have SQL Prompt replace the constant(s) with the correct column names.
4 votes -
Check is left and right are the same, and always true: like Where [Column]=[Column]
Check if left and right are the same, and so always true:
like Where [Column]=[Column]
or Where @var1 = @var 1 ..this is a big mistake .. just happened to me ..
4 votes -
«Script as INSERT» should include SET IDENTITY_INSERT «table name» ON & OFF
When using the «Script as INSERT» functionality, I always have to manually wrap the INSERT statements with SET IDENTITY_INSERT «table name» ON and OFF.
The state of the IDENTITY-property of the PK is available. Would you please at least include a togglable property to allow for the automatic addition of this very useful functionality please?
3 votes -
Bulk Action - Qualify Object Names
Run Qualify Object Names operation without having to open each file in SSMS.
I want to be able to apply best practices in bulk. Opening individual files and running qualify object names is very time consuming. It would be nice to do this operation in Bulk on a folder or list of files.
1 vote -
Offer to do update when client is closed
Rather than reminding about updates, it would be helpful to offer the ability to do a pending update as soon the client has been closed, as Visual Studio now does.
4 votes -
Include snippets in command palette searches
It would be useful to have snippets included when searching in the command palette. Selecting snippet would open snippet editor with focus on the selected snippet.
1 vote -
foreign key follower
There is a feature that was in WinSQL where each field in a column would have a little plus sign if it had a foreign key. If you click the plus sign it would look up that value in the table with the foreign key in a new tab (it would give a choice of tables if there are more than one, then do the lookup).
It was very useful and a great learning tool; it would be a great addition to SQL Prompt. Pictures attached.3 votes -
remove square brackets from keywords like MATCH clause in a graph table join
when formatting SQL, do not automatically add brackets to the MATCH clause when querying graph tables
1 vote -
Include views and unsaved tabs in recoverable tabs
When SMSS closes (either by user interaction or unintended closure), SQL Prompt does not save the tabs when I am working in a view. It only saves the tabs that are queries, saved or unsaved. The problem with this is that many times I am creating a view, or working with views. These are never saved with SQL Prompt, so the tab history feature is more or less useless. Redgate needs to include views and unsaved tabs in the recoverable tabs list.
1 vote -
Bulk Formatting or Bulk Code Analysis
It would be nice if the new Bulk Formatting or Bulk Code Analysis functionality could also target items directly in the database. This would save time because I wouldn't first have to save objects definitions to my computer.
1 vote -
Allow GitHub public sharing of snippets and styles
Allowing styles or snippets to be shared publicly would be a great feature. This could be potentially be done using GitHub repos and/or Gists.
1 vote -
Share tabs between clients
Currently I'm onboarding a new laptop. I've been given a few weeks to offboard my old laptop so I'm working between the two. Additionally I sometimes work on a jump-box.
All 3 of these instances are logged in with my SQL Prompt credentials. I have a solution for sharing my Snippets, Connection Coloring, and Styles between these machines. However it would be nice also if I could re-open a tab from my old laptop on the new laptop (or the jump box) as and when I'm switching between machines.
5 votes -
Align SET statements around = sign
I am a brand new user (1 day) for SQL PROMPT. I managed to get my parameter statements to align, but there is no option on my custom formatting style to align my set statements. See the attached jpg. Trying to get it to look like the yellow highlighted area.
4 votes -
Load built-in functions first in the suggestions list
Would it be possible to load built-in functions into the suggestions menu first (or alternatively, ignore keystrokes until the suggestion list is fully loaded)?
An example scenario is I type "max(" and it picks up the first user-defined object name from the menu. It appears the built-in functions are loaded after the user-defined objects (although they appear at the top).
In the attached file, the example is that MaxActionId will be selected when I type "max(" too quickly. This is a small but irritating problem because I have to remember to wait momentarily after typing a function name to avoid…
1 vote -
Add Per Database table/view alias mapping dictionary for use with Qualify object names
It would be nice to have a setting per database in SQL Prompt that would allow us to set an alias to tablename mapping and these settings can be shared / stored in source control for other developers.
When we run the qualify object name operation it could look at this dictionary and automatically inject an new alias for an old alias or table/view with no alias.
This allows us to have consistently alias'd tables across all sql objects in source control.
2 votes
- Don't see your idea?