276 results found
-
One line SQL from context menu - Opposite if Format SQL
Have a function which is the opposite to 'Format SQL' so you can select a section of text and have all the Line Breaks and padding taken out. Currently I use HTML Shrinker Pro to do this, but it would be nice to select a block and one line it eg..
@DateAppointed = CASE WHEN LEN(DateAppointed)> 1 THEN DateAppointed ELSE @Unknown END ,2 votesSQL Prompt 7 has an “Unformat” action in the new Actions list. The full release notes can be found here http://documentation.red-gate.com/display/SP7/SQL+Prompt+7.0+release+notes
-
Format SQL so keywords are right aligned
SELECT Number1
,Number2
,Number3
FROM table r
JOIN table2 tf
ON r.column = tf.column
AND r.column = 0
WHERE column = 0
AND column1 = 22 votesThis feature was released in version 8 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Please add a function key to reopen the sqlprompt box.
Here’s what’s happening: I am typing along and I hit space instead of tab which does not complete the fill in (I actually like this so I don’t want to add the space as a completion key). I would like a mappable key combination to get the prompt to re-open.
2 votesCtrl+Space will bring back the suggestion box, but also the latest build of Prompt will bring it back if you just continue typing after you left off (if you didn’t purposely hide it with esc)
-
Enable prompting within a raiserror()
For any attempt to use Intellisense within a RAISERROR() there is no prompting - list says "No suggestions".
Sample:
RAISERROR('Not at 12hrs UTC - time is %s',0,1,@<<Nothing-here>>) WITH NOWAITAlso reported as a defect on the SQL Prompt Forum
2 votesThe latest version of Prompt should give you suggestions within a RAISEERROR
-
Script Object as ALTER feature should not use cached scripts
Please see forum thread http://www.red-gate.com/MessageBoard/viewtopic.php?t=14749
I ran into what I would consider a serious issue with the Script Object as ALTER feature. A few hours earlier I had changed a stored procedure script and executed the Alter script so the change was now "active".
A few hours later, within the same SSMS application (but different query window) I used the right-click Script Object option as a shortcut so I didn't have to scroll through a very long list in Object Explorer... Unfortunately it scripted the OLD version of the procedure and not the one changed hours earlier.
Now, I know…
2 votesAs of SQL Prompt 5.2.8, Script as ALTER will always fetch the script directly from the database.
-
Invert Aliasing
As you select a Table say LotBaseLog , we get auto aliasing to give
Select * from LotBaseLog as lbl
What about using the alis in reverse
Select * from lbl
Gives
Select * from LotBaseLog
Have a look at Resharper Camel Hump principal
Maybe an even better shorthand
Mike
2 votes -
identify occurrences of select *
Now that sql prompt and refactoring have been merged, how about a means of identifying where 'select ' has been used in stored procedures etc. including select a. and select bob, *
I would have thought that you've already done the hard work, as SQL prompt already recognises these stars when it proposes to expand the column list.2 votesWe’re happy to announce that this feature is now included in SQL Prompt V9 as part of the new code analysis feature. For additional information see: https://documentation.red-gate.com/display/SP9/SQL+Prompt+9.2+release+notes.
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
Thank you for your help!
Kind regards,
The Prompt Team
-
Keyboard shortcut for Snippet Manager
It would be great to have a Keyboard Shortcut to launch the Snippet Manager. I currently have it as a toolbar button, but a shortcut would be good so I don't have to leave the Keyboard..
1 voteThanks for posting your comment about how you set this.
You can also do this using SQL Prompt's Command Palette - Alt+S in SSMS (Alt+P in Visual Studio) and then start typing snippet - https://documentation.red-gate.com/sp/command-palette.
-
support for create external table as (CETAS)
SQL Prompt is throwing an error when the syntax for CETAS is included.
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-cetas
1 voteSupport shipped in 10.13.9 https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-13-release-notes
-
When generating Insert code use defaults
If you create a table with a BIT column not nullable with a default value, and then you type insert, the autocomplete gives you null for the bit column. Example below. (I haven't looked at what happens with other data types/defaults.)
CREATE TABLE dbo.MyTable
(
Flag BIT NOT NULL CONSTRAINT DFMyTableFlag DEFAULT (0)
)
GOINSERT INTO dbo.MyTable
(
Flag
)
VALUES
(NULL -- Flag - bit
)1 voteHi,
This feature has actually just been added to SQL Prompt, and will be included in the next release (10.6.11).
Thanks,
Owen
-
Be able to open a tab from tab history even when no other ssms tabs are open
Currently when you attempt to open a tab from tab history and there are no other tabs currently loaded in SSMS the attempt from tab history freezes SSMS and causes it to crash. A feature that made that not happen would be good.
1 vote -
Integration with Visual Studio 2017
I'm using SQL Prompt with both SSMS (v18.5) and Visual Studio 2017 (version 15.9.23). Everything was working fine in both environments but since updating SQL Prompt to version 10.2.1.15260 I've completely lost all SQL Prompt integration in Visual Studio.
I'm aware that Visual Studio 2017 includes SQL Prompt Core but I'd always shied away from using that because I couldn't see any evidence that it would keep itself updated. When I'm building a new solution that requires a database component I find it useful to be able to add a Database project so that I can source-control everything in the…
1 vote -
Download install exe option during Check For Updates
Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".
1 voteWe added this option in Prompt 9.5.3. Hope it helps, do let us know if you have any further feedback.
https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes
-
Download install exe option during Check For Updates
Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".
1 voteWe added this option in Prompt 9.5.3. Hope it helps, do let us know if you have any further feedback.
https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes
-
Bring back the Ctrl+B, Ctrl+B hotkey for removing square brackets please. I used it all the time and the last update seems to have removed
I updated to SQL Prompt 9.4.7.7595 yesterday and since then I no longer have the hot key. It is still on the menu, but no hotkey. I used that feature hourly. If you wish, allow users to define the hotkey combinations or disable them, but simply removing them is inconvenient.
1 voteThis was a bug that has been fixed in SQL Prompt 9.4.8. Please upgrade to that version (or later) to restore the functionality.
-
Formatting of AT TIME ZONE
In SQL Server 2016 it is now possible to calculate between timezones. Currently it gives me an error, when I want to format it. The syntax is also not allowed at the moment.
1 voteAT TIME ZONE is now supported in SQL Prompt 7.4
You can download the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
-
create or alter
SQL server 2016 SP1 introduced the "CREATE OR ALTER" PROCEDURE/VIEW - syntax, which would be very nice to have support for.
1 voteThis feature was released in version 7.3 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team -
Formatting of Valid Selected code when there is invalid code in the script
I used to be able to format selected code, as long as it was valid. Now when I select code that is valid in a larger script that has invalid code it does not format the selected code at all. If the invalid code immediately precedes it it will suggest that there is an error in the first character of my selection when there is none, else it will just act like it did something but do nothing. This used to work and is a frustration now. This has been the case with both 7.3 betas and I believe at…
1 vote -
format is now deleting extra lines after the query
Looks like version 7.3 of SQLPrompt removes all blank lines after the query that it formats. Please change this back or make it optional to delete blank lines at the bottom of the query.
1 voteWe’ve just shipped a new beta build (7.3.0.619) that will preserve the extra lines at the end of the query if “Preserve existing new lines between statements” is checked.
You can download the latest beta build from https://forums.red-gate.com/viewtopic.php?f=169&t=79994
-
DBCC SHOW_STATISTICS('...','...) WITH DENSITY_VECTOR
Hi!
It would be nice to have an IntelliSense for the DBCC SHOW_STATISTICS command.
When typing
DBCC SHOWSTATISTICS('HashAggregation','WASys00000001_2A8B4280')
it would be helpfull to get the option of "WITH DENSITY_VECTOR" for example.
1 voteThis feature was released in version 7.3 of SQL Prompt.
If there are any missing features please let us know by creating a new suggestion.
Kind Regards,
The Prompt Team
- Don't see your idea?