674 results found
-
Add SQLPrompt feature into SQL MultiScript
Add support for intellisense in SQL MultiScript using SQLPrompt
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 -
«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?
4 votes -
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 -
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 -
Tab History should include non-SQL files
SSMS homes files other than .SQL scripts. Sometimes an you closed an execution plan or a deadlock graph you wish you had saved. Tab history should cache non-SQL file types along with standard SQL scripts so you can get these back when you accidentally closed SSMS or after a crash.
1 vote -
SQL Prompt Support for Azure Synapse (Azure SQL Data Warehouse)
Please add support for
SQL Prompt Support for Azure Synapse (Azure SQL Data Warehouse)49 votes -
Moving commas INDEPENDENTLY between front and end (for debugging mainly)
DAX Studio has a splendid feature that I think is missing from SQL Prompt and could be rather easily implemented. In DAX Studio one can switch with one mouse click between putting commas before or after the column names. The "before" option greatly speeds up debugging but such formatting should not be left in production. In prod we want to have commas after the column name. Would it be possible to add a quick action or option to SQL Prompt so that commas are immediately placed at the end or beginning of column names? I know there are formatting styles…
4 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 -
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 -
Add "Clean install" option during installation
Add "Clean install" checkbox with appropriate warnings and option to back up styles and tab history where the user can specify and/or change the suggested backup location by default. Offer an easy option (inside menu?) to restore from the backup once installed. Take a look at Visual Studio editor options can be exported (backed up to a file) and subsequently restored later.
Also, take a look at nVidia, AMD Radeon (formerly ATI) and perhaps Intel network card driver installers as an example for "clean install".
1 vote -
Correctly bracket Windows users/groups when using CTRL+B,CTRL+B
When adding brackets via CTRL+B,CTRL+B, Windows-based principals (users, groups, etc.) are not correctly bracketed. The brackets are placed around the domain or computer name portion of the principal, instead of the combination of the domain/computer and user/group name.
For example, if this statement is entered
ALTER SERVER ROLE sysadmin ADD MEMBER MYDOMAIN\USER
using CTRL+B,CTRL+B will yield this:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN]\USER
instead of the correct syntax:
ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN\USER]
Would also be helpful if principals from NT AUTHORITY and NT SERVICE could be correctly handled.
1 vote -
Switch between Alias formats AS/=
A formatting feature to change syntax between these two forms
SELECT field1 AS Alias1, field2 AS Alias2 FROM table1
SELECT Alias1 = field1, Alias2 = field2 FROM table1
Ideally useable without having to invoke the "Format SQL" command.
Hopefully selectable as an enabled option within a Format SQL style set.I spend a non-trivial amount of time reformatting SQL code for leading/trailing comma placement and alias AS/= placement, this would be a HUGE help
7 votes -
Object tooltips
Include SQL statements to grant existing permissions with the object definition DDL statements.
i.e. GRANT SELECT ON dbo.table TO sql_user1 vote -
Option to prevent removal of brackets on database and server names
Removing brackets from database names causes VS schema compare to indicate file differences because VS requires database reference variables to be enclosed in brackets. Need an option to exclude removal of brackets from database and server in three and four part names.
6 votes -
Debugger for SQL Code
After removing of SQL Code debugging features beginning with Management Studio 18, it would be quite welcome to have this feature in SQLPrompt.
Other competitors are already providing debugging.9 votes -
Option to align AND conditions with ON clause
Would love to have the option to have all conditions (AND / OR) aligned (or same indentation) with the ON clause, for example:
FROM dbo.orders AS o
JOIN dbo.orderAttributes AS oa
~~ON oa.companyID = o.companyID
~~AND oa.orderID = o.orderID5 votes -
Indent FROM clause
Allow the FROM, WHERE, GROUP BY, etc. clauses to indent from the select.
Change
SELECT Col1,
Col2
FROM Tab1
WHERE a = bTo
SELECT Col1, Col2 FROM Tab1 WHERE a = b3 votes -
export to excel bug(?) -- Acts odd if multiple result sets
Before I upgraded to latest version of SQL Prompt, if I had two queries in the same "New Query" window and ran them, I could select either of the two result sets and choose "Open in Excel" to open up the selected result set in Excel. Now it always seems to auto-select the first result set.
What I'm usually doing here is two related queries. I pick the larger result set, open that in Excel, and then add a new tab to Excel and copy-and-paste the smaller result set to the 2nd tab. Or sometimes I'm doing multiple queries to…
3 votes -
Secure tab history
Either detect and scrub passwords from tab history, or store the history files securely so they can't be copied by backup software and viewed as plain text on the drive without a password.
5 votes
- Don't see your idea?