679 results found
-
Add option to indent code between BEGIN TRANSACTION and COMMIT TRANSACTION
Someone else has submitted this suggestion and it is marked completed. However, it does not seem to do so in my version of SQL Prompt (9.2.6.6145)
9 votes -
Use named parameters when encapsulating as new stored procedure
It would be nice if the "Encapsulate as new stored procedure" logic used named parameter style so I don't immediately get ST008 in my code which calls the new proc.
4 votes -
Don't allow for aliases that match snippet acronyms
What I sometimes run into, is that a table gets an alias (by SQL prompt), that matches an acronym for a snippet. Then, whenever I'm writing out my query, while calling the table by alias, snippet manager replaces the alias with the full snippet. Which can be annoying as Ctrl-Z doesn't work.
My suggestion would be to check the snippet manager before assigning aliases and not have them overlap.
Thanks.3 votes -
Issue code SC003 when USE is first line
Issue code SC003 shouldn't happen if the USE statement is at the top of a SQL script.
3 votes -
Script Temporary Table Declaration from Query
Context menu item to take the current query under the cursor and script out an appropriate DECLARE @table or CREATE TABLE #table to match the names and types output from the query.
6 votes -
SQL Prompt storage of settings
As we are using a dedicated group of virtual machines for using our high privilege accounts, we don't know at login time on which machine we will have a session. Currently the settings of SQL Prompt are stored under “…\AppData\Local...”. After each logoff we loose these settings. According to the Microsoft standards, the settings should be stored under “…\Appdata\Roaming...”. Could this be changed in a future version?
1 vote -
Add formatting support for OFFSET and FETCH NEXT
The Format SQL command currently overlooks these keywords and they end up appended to the last line of the ORDER BY clause. Ideally, I'd like to have the option to place both OFFSET and FETCH NEXT on separate lines, aligned just like the SELECT, FROM, WHERE, and ORDER BY keywords.
3 votes -
Autocomplete stored procedure using local time zone on datetime arguments.
When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the local time zone.
1 vote -
Autocomplete stored procedure using local time zone on datetime arguments.
When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the local time zone.
1 vote -
Smart Rename auto-generate synonym
It would be incredibly useful to have Smart Rename have the option to generate a synonym that points the old name to the new one, in order to maintain functionality for any legacy applications accessing the database via those old object names.
1 vote -
Add $Query$ to execute when inserting a snippet
Add $query$ to SQL prompt that allows you to define a query which get executed and the results pasted in place, optionally formatted as VALUES statement
I currently have a snippet that runs
SELECT '(' + CAST(r.RegionId AS VARCHAR(50)) + ',''' + r.RegionDescription + ''',0),'
FROM retail.Regions r
WHERE r.ActiveTo > GETDATE()
ORDER BY r.RegionDescriptionI then copy the output and use the $paste$ place holder in another snippet to paste in
DECLARE @regions TABLE (RegionId INT, RegionDescription VARCHAR(50), Active bit)
INSERT @regions (RegionId, RegionDescription, Active)
VALUES
--$PASTE$ goes here
(117,'Anglia',0),
(119,'Greater Manchester',0),
(145,'Hampshire',0),An improvement would be remove the…
2 votes -
Aliases -> Prefixes to ignore with Regex
Please add option to specify regular expressions to ignore prefixes.
So if I have a pattern for table/view/SP prefix I would not need to specify all the options/combinations.Thank you
1 vote -
Management Studio 18.0 Support
SSMS 18.0 support, the latest till now, doesn't support ssms 18 preview 4
5 votes -
Automatic Alias from Table Name
(5 previous votes)
Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.
eg.
Customer = C
mem_Membership = Mcus_StateCustomer = SC
aReallyLongTableName = RLTN
view_CustomerMembership = CM
4 votes -
Control the behaviour of SQL Prompt insertion
I would like the ability to control how SQL Prompt completes my statements for me, this mostly becomes an issue with procedures with multiple optional parameters.
If I used sp_whoisactive as an example, there are multiple optional parameters but it is capable of running with no parameters at all, so I find myself having to spend longer than I want to either highlighting the bit I want execute or deleting all the parameters that just got written for me.
So a setting where I can assign keys to complete full statement and keys to simply complete object name would be…
1 vote -
Tab History
Tab history grows considerable with tabs that you don't care about. How about a hot key combination so that when the tab is closed it does not add it to history. Example: While holding the ctrl key down I close a tab and this prevents it from being added to history.
7 votes -
Colon style parameters
Some programming languages (we use FireDac in Delphi) use colon notation to declare variables. Eg
select * from table where id = :id;
Testing such queries in SQL Prompt forces you to change the query before and after testing and that is error prone.
It would be nice if SQL Prompt could handle this type of parameters by instead of raising an error show a "Enter parameter value" input box.1 vote -
open source sql prompt's formatting module.
open source sql prompt's formatting module.
1 vote -
AND keyword for WHERE and JOINs on new line
There is no option in CLAUSES > JOIN to place AND on new line (Right aligned to INNER) and in Data (DML) there isn't an option to put AND on new line. Lots of tables I join on I am joining on 2 columns and I prefer to have the AND a.col1 = b.col1 on a new line as well.
4 votes -
Format of Valid Selected Code when there is invalid code in the script (Take 2)
Version 9.2.5.6073
I would like to request that script validation be limited to the selected text during Format SQL.This is a duplicate of a Completed feature (Bug) submitted on version 7. https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/16611622-formatting-of-valid-selected-code-when-there-is-in
I see recent comments on the original request but you may not be addressing since it is marked completed.To Replicate:
Put 3 lines below in a new Window in SSMSSOME BAD TEXT
GO
SELECT 1 FROM dbo.PersonNow select All of Line 3 after the GO Statement. Right-click, Format SQL
Should get following error:
"Error inserting semicolons" ...
Script parsing errors:
Line 1 Col: 1…6 votes
- Don't see your idea?