669 results found
-
materialise temp table (from SELECT INTO)
I pick up LOTS of legacy code with SELECT INTO statements.
sometimes they are into temp tables but also in physical tables.
It would be great to be able to highlight the statement in the SQL and right-click and choose to automatically convert it into a TRUNCATE + INSERT INTO (whilst running the CREATE TABLE statement for me)
for example:
/This is the statement I start off with/
SELECT TOP 10 *
INTO dbo.example_table
FROM sys.objects/SQL prompt pops up with dialog box to choose the table name and creates the table for me/
CREATE TABLE…2 votes -
Macro Recorder
Create a plugin to record and replay keyboard commands like notepad++ or sublime.
2 votes -
'Copy as IN clause' orizzontally too
hi, i'd like to have the function 'Copy as IN clause' not only when i select data vertically but orizzontally too
1 vote -
Tab History Window Behaviour
Can the tab history window, when maximized, be made to consider the maximum screen size when it's popped out?
I have monitors that have different resolutions and if I pop it out on my smaller screen it doesn't fit and I loose the top of the screen with the search and tabs - but most annoyingly that also means I loose the window bar so can't control the size either!2 votes -
Show only column names in intellisense while doing SELECT
Its really annoying to see table names suggestions in the intellisense while typing SELECT statement. I feel its not the new feature but its the bug to be fixed.
4 votes -
Add option to choose Single/Multi-line script for INSERT and EXECUTE statements
Currently SQL Prompt inserts SQL full INSERT script or EXEC SP in multiline while it might be useful for INSERT statement, but most of the times I have to realign them into a single line. It would be good if we have the option to choose wheather to add statement in single line or multi line? and its more usefull if we have shortcut to switch the inserted statement between formats?
2 votes -
Dark mode support
Dark mode support across all red gate tools.
9 votes -
Add possibility to make snippet for "GROUP BY 'by all non-aggregated columns'"
I use GROUP BY only for 'by all non-aggregated columns' in 99% of cases. I've created snippet for GROUP BY (gb) and then I pick this option from the intellisense menu. It would be nice to have possibility to have snippet that would add these 'all non-aggregated columns' automatically most probably by adding new variable.
3 votes -
Copy as IN clause - Allow second column as ID comment
So… Copy as IN Clause. Love it, but let’s improve it. Let’s say we have the following output…
ProductID ProductDesc
1 SQL Prompt
2 SQL Search
3 SQL CompareIf we use Copy as IN Clause on the ProductID column, we get:
IN
(
1,
2,
3
)Which super…. However those IDs mean nothing to me in 6 months time when I’m now having to modify my code. What would be awesome, is if I can select both ProductID and ProductDesc, then hit Copy as IN Clause, and get the following output:
IN
(
1, -- SQL Prompt
2,…5 votes -
Don't add trivial queries
Add an option to filter what tabs are moved into history.
- SSMS autogenerated queries are of no interest.
- So are simple DML and EXEC[UTE] queries consisting of one statement.
- Successful executed ALTER {PROC|VIEW} are of no interest.
Optionally calculate a query complexity value or class to hide simple queries.
5 votes -
Tab ageing - automatic deletion after X days / weeks / months
Add a configuration option to automatically delete tabs by age (last executed or tab closed).
Or move them outside the normal tab history (archive them) to speed up the normal history loading and searching.
5 votes -
Warn about always true WHERE clauses such as ID = ID instead of ID = @ID
It is common to create functions and stored procedures that have parameters with the same name as fields. Sometimes the @ is mistakenly skipped when creating a WHERE condition and you end up with something like ID = ID instead of ID = @ID. I would like intellisense that warns me about this type of error.
2 votes -
Use SQL Prompt editing settings in other tools (like MultiScript)
When I am composing a script in Multi-Script, I'd like to have the editing settings available. Include variable/column name completion, keyword formatting, indention, etc..
2 votes -
Script as INSERT
Fix "Script as INSERT" functionality with dates.
Currently when I use this great functionality all the datetime fields will get a form N'1900-01-01T00.00.00'.
Unfortunately the Finnish SQL server settings does not recognise that and running this script gives an error "Msg 241, Level 16, State 1, Line 2
Conversion failed when converting date and/or time from character string.". I have not been able to find a way to change that date format in SQL Prompt Options.1 vote -
backup
I would like to see intellisense provide you a list of backup devices that are created when you use the backup database key words.
Backup database [database names in drop down] to [ disk, file, Url, backup devices in dropdown]
1 vote -
Autogenerate variables based on correlated field
When writing SQL, I frequently will create a variable within the statement before I have Declared the variable. It would be great if SQL Prompt offered a UI option to autogenerate the variable declaration.
For example, given the statement:
SELECT * FROM dbo.Person WHERE Username = @Username
I would like to use a shortcut key to auto generate and insert the declaration above the statement:
DECLARE @Username VARCHAR(8);For simple fields, the data type can be pulled directly from the field metadata. For expressions, derive the data type as SQL would if possible, or move the cursor to the data…
6 votes -
Begin statement is not starting on a new line within an If statement. Please allow this in format styles. The option is there but it doesn't
When Place Begin - End statements on new line is selected it doesn't appear to work as part of an If statement. This makes the begin and end difficult to find
2 votes -
Script object as alter also in 'CREATE OR ALTER' statement
'Script object as alter' (F12) works in ALTER statements but not in CREATE OR ALTER statements like. It would be nice if it also worked for the latter.
Example:
'CREATE OR ALTER VIEW [MyView] AS SELECT 1 AS Col1;'
If I right-click on [MyView] in the above code snippet and select 'Script object as ALTER' (or hit F12), I would expect SQL Prompt to script the object if it exists.
Currently nothing happens.5 votes -
Snowflake
Please add Prompt features when connecting to a Snowflake database
2 votes -
Custom Formatting and Refactoring (API)
I would like to expand upon suggestions others have made regarding adding custom formatting and analyzers.
I have recently been trying to implement SQL Prompt for our team, and I have struggles with a lack of customization, opinionated options that don’t reflect our needs, and some bugs.
What would have solved this issue for me would have been the ability to add custom formatters and custom analyzers.Custom Formatters
Since SQL Prompt gets the position of tokens from IAlignmentProvider.FinalAlignmentForToken I suggest that the API couple simply be plumbed into this method, if a plugin is attached it would call the…3 votes
- Don't see your idea?