663 results found
-
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.
5 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 -
Add Feature to Qualify Object Name on files in a folder / directory / sql database
As SQL Prompt user, I want to be able to perform a qualify object names operation on a directory of views, tables, sprocs, etc.
Currently, one must open a sql file in SSMS first then run the qualify object names operation on each file. This is extremely time consuming. We are trying to improve our code quality and readabily by following best practices.
1 vote -
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 -
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 -
Version Specific Snippets Script Blocks
I would like to be able to specify different script blocks inside a snippet that would work differently based upon the sql server version of the server I am connected to.
Or.... optionally have a version indicator on the snippet to perform the same thing. Then if two snippets share the same name it would apply the correct one based upon version.
EX:
…:if $version_major$ >= 13 CREATE OR ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN $CURSOR$SELECT @param1 END GO :else IF OBJECT_ID('[$dbo$].[$proc_name$]', 'P') IS NULL BEGIN EXEC('CREATE PROCEDURE [$dbo$].[$proc_name$] AS BEGIN SELECT 1; END;') END GO ALTER PROCEDURE [$dbo$].[$proc_name$]1 vote -
SQL Doc
Since there is no listing for SQL Doc requests, I was advised by support to enter this under SQL Prompt. When generating the documentation for stored procedures, functions or views, the "Uses" section only includes objects from the same database where the procedure resides. We have many objects that use tables located in other databases so it would be extremely helpful if SQL Doc could include them in the "Uses" section of the documentation.
1 vote -
Click to run pinned queries
I often find myself in a scenario where I am doing something like:
1. Mock some data (SQL query)
2. Perform a front end action as though I'm a user
3. Check some data (SQL query)
4. Alter a procedure (SQL query in a different window)
5. RepeatI think it would be nice if I could pin the mock/check queries to a window in the side of the manager so that I could click to run them instead of having to click in them then shift+f5 or whatever. And even more nice not having to have a second editor…
1 vote -
restore from url breaks SQL formatter
The below script causes SQL Formatter rules to fail with the error "Script parsing error(s) ... Incorrect syntax near url. ... Failed refactorings: Insert semicolons (Script parsing errors)"
create database foo; go backup database foo to url = N'https://foocorp.blob.core.windows.net/backups/foo/foo_1.bak'; go restore database foo from url = N'https://foocorp.blob.core.windows.net/backups/foo/foo_1.bak'; goSSMS Parse (
ctrl+F5) reveals that this snippet parses correctly. When replaced with a valid URL target, this syntax also executes without error.Please update the semicolon rule and any other necessary rules to handle for backup/restore from URL as a valid formattable syntax.
(possibly related? https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/40184173-format-sql-backup-to-url-with-credential-breaks-co)
1 vote -
Compare the output and speed of two stored procedures
Add a new window that compares the output (and speed) of two stored procedures using the same parameters (ignoring parameters that are missing on either side).
When fixing performance problems or adding new parameters to existing stored procedures, we often need to rewrite large portions.
After successfully speeding it up, we need to test if the results are still correct.
One way to do this is to compare the output of the new procedure with the output of the old one using different parameters. This involves storing results in temp tables, sorting them, output to a text file and using…2 votes -
Generate C#/VB.NET class
It would be nice to have the ability to right-click on a table or stored procedure and generate a C# or VB.NET class from the table structure or stored procedure results that could be used in a development solution.
3 votes -
Identify Duplicated Variable Names
I was a bit surprised that SQL Prompt does not Identify and highlight duplicated variable names. Seems like an important omission.
Please extend the 'Find Unused Variables' to include identifying any duplicated variable names.
1 vote -
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 -
Have formatting features for cross join match those of left/right/inner join
I have set up rules to format as such:
Select *
From Employees e Join
People p On e.PersonID = p.PersonID;Each table/view object aligned on a new line. However, when I convert to a "cross join", they don't generate a new line, they concatenate on the same line, like such:
Select *
From Employees e Cross Join People p;3 votes -
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
- Don't see your idea?