638 results found
-
Fix closing quote for 'N' strings
When typing a string preceded with 'N' (like N'string value'), when you type the closing quote it gets doubled. Hard to explain, but easy to reproduce. Just type these two statements into SSMS to see the difference:
SELECT 'Bill' As FirstName
SELECT N'Bill' As FirstName1 vote -
Copy results as Markdown Table
When right-clicking in the results tab, SQL Prompt should offer the posibility to copy the results as a table with markdown formatting (for Stack Overflow / Stack Exchange network). See https://meta.stackexchange.com/questions/356997/feature-preview-table-support for the syntax.
1 vote -
Smart Rename should be smarter about changing schema &table name
When renaming both the table and schema name, and a table already exists w/ the old table name but new schema name, Smart Rename errors because it does not detect this conflict and tries to first rename the table to the conflicting table name.
e.g., renaming stage.dboTable1 to dbo_stage.Table1 (and stage.Table1 already exists):EXEC sp_rename N'[stage].[dboTable1]', N'Table1', N'OBJECT' GO IF @@ERROR <> 0 SET NOEXEC ON GO ALTER SCHEMA [dbo_stage] TRANSFER [stage].[Table1] GO IF @@ERROR <> 0 SET NOEXEC ON GO
would work if script instead did this:
…ALTER SCHEMA [dbo_stage] TRANSFER [stage].[dboTable1] GO IF @@ERROR <> 0 SET NOEXEC
1 vote -
Find Invalid Objects not working in v10.4.2 (SSMS 18.5, 18.6)
Find Invalid Objects not working in v10.4.2 (SSMS 18.5, 18.6)
1 vote -
syntax highlight double quoted column aliases
SQL prompt doesn't offer a single quote column aliases (which is fine). The code analysis feature says :
"If aliases are standard identifiers, they do not need delimiters. If they are not, then they should be delimited by double-quotes, not single-quotes."
what would be good is if SQL prompt had an option within SSMS to highlight double quoted column aliases in another colour (purple perhaps) just to make code more readable... sometimes the sea of black is hard to read when you have long, complex case statements etc.
1 vote -
'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 -
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 -
Smart Rename on Service Broker Objects
Smart Rename should work on service broker objects. These objects: Message Types, Contracts, Queues and Services are all interdependent. Renaming Message Types, for example, requires the dropping of the dependent Contracts, which in turn requires the dropping of the dependent Services.
It would be great to be able to generate the relevant drop and create sql in one hit.1 vote -
Use a cell pattern to format NULL values in "Open in Excel" feature
When using the feature 'Open in Excel' for grid results, I'm unable to determine in Excel which database values were empty strings vs. NULL values. I like that it no longer exports the word 'NULL', but I'd like some sort of option to be able to make a distinction between the two.
My idea is to use a cell fill pattern (Format Cells + Fill + Pattern Style), but I would be satisfied with just about anything to be able to make that distinction. The pattern I recommend is the most sparsely dotted option, which shows a tool-tip of 6.25%…
1 vote -
improve right click performance
When I right click in a Stored procedure SSMS hangs, and it takes too long for the menu to show up. Please review Red Gate Source Control for the added entries in the menu to improve performace
1 vote -
Add "Set as Active Connection" to Registered Servers
This is essentially the same as a forgotten SSMS request over here: https://feedback.azure.com/forums/908035/suggestions/32896039
It would be incredibly useful to be able right-click on a server-node in the Registered Servers list and change/set the connection for the current document window to that. You already have a custom context menu item in there ("Tab Color (Server)", so that hurdle is gone.
This idea is related to these, but not quite the same. In both cases, it seems they don't know about the Registered Server functionality, so they're basically asking for this idea, plus for you to re-implement that entire feature.
https://redgate.uservoice.com/forums/94413/suggestions/40385740
https://redgate.uservoice.com/forums/94413/suggestions/134251351 vote -
Suggestions window should display CREATE sql for CLR objects
No CREATE SQL is displayed in the suggestions window when hovering over any CLR objects, or scripting the object as alter. The code returned is just a comment saying:
-- No creation SQL available for this object type
The CREATE/ALTER statement can easily be built by querying the relevant system tables. SSMS does it when you script the object and other Redgate products such as SQL Compare and SQL Source Control do it just fine, not sure why SQL Prompt would have been left out.
1 vote -
Remove dependance on USE [dbname] in Query window.
Many time SQL Prompt doesn't work for me because it thinks I use the database mentioned in the last USE statement in the SSMS query window. This is incorrect and confusing since I change the database in the SSMS dropdown without explicit running any USE statement. SQL Prompt should know what database is selected in the dropdown and offer objects from the selected database,
1 vote -
Put DISTINCT Keyword At Top of Suggestions List
Add an option to have the DISTINCT keyword appear at the top of the suggestions list when the first few characters (DIS, DIST) are typed, ahead of any column name suggestions. Nearly every time I type DIS or DIST, I want the DISTINCT keyword and not a column name that begins with the same letters.
1 vote -
A one-click option to minify the selected/entire code
I would like to request a one-click option (or at least an out-of-the-box Format Style) that would minify either the selected line(s) or entire code in the current session.
This would be really helpful when writing a non-dynamic TSQL that will need to be turned into dynamic to save on (VAR)CHAR limit (4000/8000).
Thank you
1 vote -
Manually define schema/foreign keys
We have a database that has Foreign keys, but doesn't have them set up as such via it's schema. It's a legacy system and there are technical reasons we aren't going to go back in after the fact and define them. I can't imagine we're the only place to ever run into this, it would be nice to have some sort of config file where you could manually set up things like that.
1 vote -
Ability to quickly change to another instance (keystroke or drop-down menu)
Switching or connecting to another SQL Server instance requires several steps. It'd be nice if there was a drop down menu or keyboard shortcut to show a list of instances. The list could be frequently used or created manually.
1 vote -
Order By - Enhancements
I often need to have Order By added and the following enhancements will help (same as in the grupy by intellisent)
- order by "Primary Keys" -> Order as in table
- order by Select-list columns -> order as in the select list
- order by Select list columns from table x
All three would help to type less
Thanks
1 vote -
Ability to integrate SQLPrompt Formatting with T4 Visual Studio
I use T4 to generate a significant amount of SQL code. It would be useful for purposes of readability especially, to be able to call the formatter from within a T4 build process.
1 vote
- Don't see your idea?